Go to DotNetFunda.com
 Online : 1574 |  Welcome, Guest!   Login
 
Home > Interview Questions > SQL Server Interview Questions > What is DESCRIBE command in SQL Server 2 ...

  • Download the OOPS, ASP.NET and ADO.NET Training Videos for FREE, click here.

call for mock interview

SQL Server Interview Questions

Submit Questions | Search Questions | Interview Home | Exclusive Interview Home |

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

Author: Neeks | Posted on: 2/22/2009 9:36:47 PM | Category: SQL Server | Views:2023 |  Print | Asked In: Many Interviews


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

Interesting?   Share and Bookmark this


Navigate to:

 Submit Interview Questions

How do you optimize stored procedures in SQL Server 2005 ...

Which is not the step to create custom SOAP (Simple Object Access Protocol) ...

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

Categories

.NET FrameworkADO.NETAJAXAptitude TestASP.NET
BizTalk ServerC#CSSDesign Pattern and ArchitectureF#
HRHTML, DHTMLIISJavaScriptjQuery
LINQNetworkingOOPSOthersProject Management
Remoting, Web Services, XML, XSLTSharePointSilverlightSoftware Testing - Quality AssuranceSQL Server
VB.NETWCFWPFWWF


Advertisement
About Us | The Team | Advertise | Contact Us | Feedback | Privacy Policy | Terms of Use | Link Exchange | Members | Go Top
General Notice: If you found copied contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.
All rights reserved to DotNetFunda.Com. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
(Best viewed in IE 6.0+ or Firefox 2.0+ at 1024 * 768 or higher)