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

What are cursors stored procedures and triggers?

709


What are the differences between sql server and mysql.

787


How do we synchronize On-Premise SQL server with SQL Azure?

114


What is catalog views?

816


Explain primary key?

736


What is the difference between a function and a trigger?

793


Can sql servers linked to other servers?

755


What is the chart in report?

125


What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

947


Using the customer, and order table in northwind database, please write a query to produce xml?

870


Is foreign key unique?

768


What are the advantages dts has over bcp?

759


Do you know nested transaction?

705


What is an inner join?

726


explain different levels of normalization? : Sql server database administration

724