Dear Srinivas, desc using in oracle not in Sql Server. sp_help <table

how to know description of a table in sqlserver 2000

Question Posted / ksantosha

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Can we create clustered index on composite key?

1166

Are resultset updatable?

1006

How will you optimize a stored procedure optimization?

1111

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1085

how to avoid cursors? : Sql server database administration

1009

Difference between report and query parameter.

1141

How do you open a cluster administrator?

1096

Which are the important points to note when multilanguage data is stored in a table?

1063

What is difference between delete & truncate commands?

1138

Explain the truncate command?

1030

Why use cursor in sql server?

1129

how to do partition in sqlserver

2545

What are triggers? How do you invoke a trigger on demand?

1363

What is indexing explain it with an example?

1065

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1056