What is DESCRIBE command in SQL Server ?

 Posted by Bharathi Cherukuri on 6/6/2012 | Category: Sql Server Interview questions | Views: 2488 | Points: 40
Answer:

DESCRIBE command is used in Oracle.
By using this command we can see the structure of the table. In SQL Server, we use sp_help fpr the same purpose.

Example:

To describe a procedure called CUSTOMER_LOOKUP, enter

DESCRIBE customer_lookup


Output:


PROCEDURE customer_lookup
Argument Name Type In/Out Default?
---------------------- -------- -------- ---------
CUST_ID NUMBER IN
CUST_NAME VARCHAR2 OUT


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response