Interested to Buy Any Domain ? << Click Here >> for more details...
how to know description of a table in sqlserver 2000
- 8 Answers
- 11616 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 |
How to find Duplicate Records In table?
What is 'write-ahead log' in sql server 2000 ?
What is intellisense?
write down the code for "how we delete a table without using of Drop command " ?
7 Answers CarrizalSoft Technologies, Sonata,
How to provide login information for a new odbc dsn?
What is the difference between coalesce() & isnull()?
How do you fine the performance tunning?
What is row_number function?
How to generate create view script on an existing view?
your distribution database is full what will u do
What is Online Index Rebuild Operation?
What is 3nf normalization?
-
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)
