sp_help <table

how to know description of a table in sqlserver 2000

Question Posted / kmbkrishnan

Answer Posted / kmbkrishnan

sp_help <table_name>

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can sql servers link to other servers?

1067

what are the new features in SSRS?

134

How to delete existing triggers using "drop trigger"?

1036

How to use the inserted and deleted pseudo tables?

945

What are database states in ms sql server?

1160

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

3852

Is sql server free?

893

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

What are the components of dbms?

938

How to write a query with a full outer join in ms sql server?

1053

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1116

Explain intellisense for query editing

1014

What is the difference between truncate and delete commands?

1043

What is the syntax to execute the sys.dm_db_missing_index_details?

1000

How to connect ms access to sql servers through odbc?

1005