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

How many types of subqueries are there in sql server?

0 Answers  


what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,


can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,


Explain different types of lock modes in sql server 2000?

0 Answers  


Explain system scalar functions?

0 Answers  






What are the OS services that the SQL Server installation adds?

3 Answers  


write sql program to get the detail of student in a class?

2 Answers  


what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  


explain the storage models of olap? : Sql server database administration

0 Answers  


explain different types of jions with examples briefly?

3 Answers   Zensar,


What the different components in replication and what is their use?

0 Answers  


When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  


Categories