DESCRIBE
DESCRIBEβ
Nameβ
DESCRIBE
Descriptionβ
This statement is used to display the schema information of the specified table
grammar:
DESC[RIBE] [db_name.]table_name [ALL];
illustrate:
- If ALL is specified, the schemas of all indexes (rollup) of the table will be displayed
Exampleβ
Display the Base table schema
DESC table_name;
Display the schema of all indexes of the table
DESC db1.table_name ALL;
Keywordsβ
DESCRIBE