how to know description of a table in sqlserver 2000

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / e-mail

8 Answers
11249 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to know description of a table in sqlserver 2000 ..

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

how to know description of a table in sqlserver 2000 ..

Answer / kmbkrishnan

sp_help <table_name>

Is This Answer Correct ?

7 Yes

0 No

how to know description of a table in sqlserver 2000 ..

Answer / ritesh

sp_ help table name
is the correct answer , above two answer is correct

Is This Answer Correct ?

6 Yes

0 No

how to know description of a table in sqlserver 2000 ..

Answer / rajeev

by pressing alt+f1 we also get the description of the table

Is This Answer Correct ?

5 Yes

0 No

how to know description of a table in sqlserver 2000 ..

Answer / punithalakshmi

sp_help is the correct answer.

Is This Answer Correct ?

5 Yes

1 No

how to know description of a table in sqlserver 2000 ..

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

how to know description of a table in sqlserver 2000 ..

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 know description of a table in sqlserver 2000 ..

Answer / srinivas

desc <table_name>

Is This Answer Correct ?

2 Yes

6 No

Post New Answer