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: 15081

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

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

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

Thanks & Regards,
Sql Developer

Login to post response