What is DESCRIBE command in SQL Server 2005? What is its purpose? How to use it?

 Posted by Neeks on 2/22/2009 | Category: Sql Server Interview questions | Views: 16027
Answer:

DESCRIBE is used to see table structure. In SQL server 2005 we can use sp_columns, sp_tables or sp_help.

sp_columns
will show list of columns and its details in table.
sp_tables will show list of tables in the database


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Sqldev on: 12/7/2012 | Points: 10
Hi,

SQL SERVER doesn't support 'DESCRIBE' Command.
This command is acceptable Sybase. But, not in SQL SERVER.


Thanks & Regards,
Sql Developer
http://learnsqltips.blogspot.com/

Login to post response