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

How to copy the tables, schema and views from one sql server to another?

551


Do you know clustered and non-clustered index?

518


How to resolve the orphan use problem? : sql server security

520


What do you understand by replication in sql server? Mention the different types of replication in sql server.

498


What is a user-defined function in the sql server and what is its advantage?

610






How to implement service broker?

519


Difference between Logical Page and Physical Page in SSRS.

337


What happens when converting big values to numeric data types?

561


How do I view a stored procedure in sql server?

509


How do you debug a procedure in sql server?

490


What do you mean by sql server 2005 express management tools?

779


What happens if the update subquery returns multiple rows in ms sql server?

581


what is normalization? Explain different levels of normalization? : Sql server database administration

645


What are some examples of schemas?

527


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

494