DESCRIBE command helps to display schema of table - Database

Q.  Which command helps to display schema of a table?
- Published on 26 Aug 15

a. DESCRIBE
b. DISPLAY
c. DESC
d. SHOW

ANSWER: DESCRIBE
 

    Discussion

  • Nirja Shah   -Posted on 02 Nov 15
    - Syntax
    DESCRIBE { table-Name | view-Name }

    - It provides a description of the specified table or view.

    - For a list of tables in the current schema, use the Show Tables command.

    - For a list of views in the current schema, use the Show Views command.

    - For a list of available schemas, use the Show Schemas command.

    - If the table or view is in a particular schema, qualify it with the schema name.

    - If the table or view name is case-sensitive, enclose it in single quotes.

    - You can display all the columns from all the tables and views in a single schema in a single display by using the wildcard character '∗'.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)