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 function of CUBE ?
How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.
What is the difference between Stored Procedures and triggers?
What is collation?
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What are the properties of the relational tables?
Explain transaction server consistency?
What's the difference between a primary key and a unique key?
sql server architecture ?
What are the Pre Requisites when you apply Srvice Packs?
Explain what are the events recorded in a transaction log?
What happens if null values are involved in datetime operations?
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)