Interested to Buy Any Domain ? << Click Here >> for more details...
how to know description of a table in sqlserver 2000
- 8 Answers
- 11599 Views
- I also Faced
- E-Mail Answers
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 |
Explain the steps to create and execute a user-defined function in the sql server?
Some queries related to SQL
How to connect to a sql server using odbc_connect()?
What is a subquery in a select query statement in ms sql server?
How do you rename a table in sql server?
Are null values the same as that of zero or a blank space?
What is @@Identity in sql?
Explain the advantages of merge replication?
What does COMMIT command do?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to concatenate two strings in SQL Server.
How to transfer data from a cursor to variables with a "fetch" statement?
-
Oracle (3253) - 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)
