how to know description of a table in sqlserver 2000
Answers were Sorted based on User's Feedback
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 |
Answer / ritesh
sp_ help table name
is the correct answer , above two answer is correct
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / rajeev
by pressing alt+f1 we also get the description of the table
Is This Answer Correct ? | 5 Yes | 0 No |
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 |
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 many types of subqueries are there in sql server?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
can any body tell me how to know the password of current user in sql server
Explain different types of lock modes in sql server 2000?
Explain system scalar functions?
What are the OS services that the SQL Server installation adds?
write sql program to get the detail of student in a class?
what are constraints? Explain different types of constraints? : Sql server database administration
explain the storage models of olap? : Sql server database administration
explain different types of jions with examples briefly?
What the different components in replication and what is their use?
When multiple after triggers are attached to sql table, how to control the order of execution?