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