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

How to loop through result set objects using odbc_fetch_row()?

951

Why do you want to join software field as you have done your BE in Electronics?

2128

Does the order of columns in update statements matter?

904

Describe in brief sql server monitoring ways.

1033

What is the difference between migration and upgradation in sql server?

1080

How many databases Microsoft SQL server provides?

1066

What is the purpose of self join?

950

Why do we use trigger?

948

Explain insert into select statement?

927

What is filter index?

933

How much memory that we are using in Logshipping Concept?

1771

How many types of triggers in sql server?

1008

Explain acid?

1054

What is repeatable read?

986

How many databases can we create in a single server?

207