Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to know description of a table in sqlserver 2000

Answers were Sorted based on User's Feedback



how to know description of a table in sqlserver 2000 ..

Answer / ksantosha

Dear Srinivas,
desc using in oracle not in Sql Server.
sp_help <table_name> is correct answer for Sql server

Is This Answer Correct ?    11 Yes 0 No

how to know description of a table in sqlserver 2000 ..

Answer / kmbkrishnan

sp_help <table_name>

Is This Answer Correct ?    7 Yes 0 No

how to know description of a table in sqlserver 2000 ..

Answer / ritesh

sp_ help table name
is the correct answer , above two answer is correct

Is This Answer Correct ?    6 Yes 0 No

how to know description of a table in sqlserver 2000 ..

Answer / rajeev

by pressing alt+f1 we also get the description of the table

Is This Answer Correct ?    5 Yes 0 No

how to know description of a table in sqlserver 2000 ..

Answer / punithalakshmi

sp_help is the correct answer.

Is This Answer Correct ?    5 Yes 1 No

how to know description of a table in sqlserver 2000 ..

Answer / sharif

Yes The Ksanthosha Given the Right Answer!

SP_HELP TABLE_NAME

This will gives the descriptin about the given TABLE_NAME

Is This Answer Correct ?    4 Yes 3 No

how to know description of a table in sqlserver 2000 ..

Answer / hameed

To get the description of the table execute this query in
the query editor
sp_help table_name

Is This Answer Correct ?    1 Yes 0 No

how to know description of a table in sqlserver 2000 ..

Answer / srinivas

desc <table_name>

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More SQL Server Interview Questions

What are the properties of the transaction?

0 Answers  


Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,


What is correlated subquery in sql server?

0 Answers  


Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  


Difference between Function and Procedure-in general?

6 Answers  


How to provide column names in insert statements in ms sql server?

0 Answers  


What is the concept of optimization?

0 Answers  


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  


What are policy management terms?

0 Answers  


How ssrs maintain security?

0 Answers  


What is sql server profiler trace data file?

0 Answers  


How to delete exactly duplicate records from a table?

0 Answers  


Categories