sql server interview questions : What is DESCRIBE command in SQL Server 2005? What is its purpose?...

thinkinterview » interview questions » SQL Server

« Previous

SQL Server Interview Questions

next »

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 »

Think

Interview

SQL Server Interview Questions

Recent Posts

Think Interview	Advertisement
Home Interview Questions Blogs Forums


	Sign In New User: Join Recent Posts Stop Being Lazy Being lazy is an axe on productive life. Following steps might help you to create more productive,How to Write a Cover Letter? Cover letter is an essential and tricky part of your job search, but I have come up with a sure fire How to Write a Good Approachable Resume? If you are about to start switching jobs or newly bird into the real corporate world, you're goi How Can I Make A Good First Impression? “First impression is last impression”. First appearance while interview is a last chance SQL Server 2005 (Database) Interview Questions 1. What is DESCRIBE command in SQL Server 2005? What is its purpose? How to use it? DESCRIBE