thinkinterview » interview questions » SQL Server
« Previous

SQL Server Interview Questions

next »
question

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

Answer Description:

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
 


Next Queston » What is RDBMS?...

What is RDBMS?View full queston »