desc <table

how to know description of a table in sqlserver 2000

Question Posted / srinivas

Answer Posted / srinivas

desc <table_name>

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

911

How to change the ownership of a schema in ms sql server?

1124

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1107

What is Dependency Injection and provide example?

1069

What is the difference between ddl,dml and dcl commands?

1080

What is nolock hint in sql server 2008

1098

Why use cursor in sql server?

1032

How to declare and use cursor variables?

1106

What are distinctive joins find as a part of sql?

924

How to move database physical files in ms sql server?

990

How do you migrate data from mssql server to azure?

165

What are the diifferences between the ms sql server vs mysql?

1141

Can you explain the disadvantages/limitation of the cursor?

941

How to create a user name in a database?

1017

‘Order by’ is not allowed in a view how can you sort information from a view?

1046