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 |
What is the purpose of the tempdb database?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What does it mean to invest in the index?
How to update muliple row in single query?
Explain unique key in sql server?
What are the steps you should follow to start sql server in single-user mode?
Define full outer join in sql server joins?
How to find index size for each index on table?
What is the difference between lock, block and deadlock? : sql server database administration
Where do we use trace frag?
What is the syntax for encrypting a column in SQL Server?