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 tempdb in sql server?
Which are the third-party tools used in sql server and why would you use them?
Why and when do stored procedure recompile?
How many ways to create table-valued functions?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain the different index configurations a table can have?
Difference between aggregate functions of sql?
How you can change the database name in SQL SERVER?
What it means to be triggered?
How can we improve performance by using SQL Server profiler?
What is the use of RDBMS?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)