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 the differences between lost updates and uncommitted dependencies?

555


What is server-level principal?

102


Where actually sql azure database is hosted?

149


Explain encryption of entire databases without the need for application changes in sql server 2008?

570


List the ways in which dynamic sql can be executed?

653






Can we install sql server 2016 on windows 7?

689


How does recursive cte works in sql server?

530


How to use subqueries with the exists operators in ms sql server?

594


How you can get a list of all the table constraints in a database?

529


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

563


What is a View ? Can we insert, Update and delete a view?

637


What are the limitations in ssrs on sql server express edition?

139


What is indexed view? How to create it?

603


Can you name some of the dml commands in sql?

554


Explain an automatic checkpoint

575