SQL Server Interview Questions

Submit Interview Question with Answer | Search Questions | Interview Home | Exclusive Interview Home |

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

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

Found interesting? Add this to:

| More

Write Response

Navigate to: Submit Interview Questions Next Question >>: How do you optimize stored procedures in SQL Server 2005 ... << Previous Question: Which is not the step to create custom SOAP (Simple Object Access Protocol) ... Random Questions: Random Interview Questions Help: If for some reason you are getting the same question by clicking Next Question or Previous Question, Try clicking Categories link above.

Related interview questions
How do you optimize stored procedures in SQL Server 2005 ... What are the properties of the Relational tables? ... What is a Linked Server? ... What is a satellite assembly? ... What does assert() method do? ... What’s a multicast delegate? ... What’s a delegate? ... When do you absolutely have to declare a class as abstract? ... What’s the advantage of using System.Text.StringBuilder over System.String? ... Class A { static byte a; static short b; static char c; static ... what is Static? ... An automatic commit ocurrs under the following circumstances ... More ...

General Notice: If you found plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 9/3/2010 4:20:46 AM

SQL Server Interview Questions

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

Related interview questions