how to know description of a table in sqlserver 2000

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about analysis services?

800


What is checkpoint in sql server?

860


What do you mean by sql server agent?

747


Explain alternate key, candidate key and composite key in sql server?

703


What happens if null values are involved in comparison operations?

751


What do you mean by data manipulation language?

794


What are different types of table joins?

788


How to include text values in sql statements?

806


Is it possible in sql table to have more than one foreign key?

824


What is difference between aggregate and analytic function?

709


What is side by side migration in sql server?

795


Is it true, that there is no difference between a rule and a check constraint?

742


What is index, cluster index and nonclustered index?

723


How do you drop an index?

713


State the difference between union and union all?

720