Skip to main content

DESCRIBE

DESCRIBE [table_name];

all of the data column will be shown

Describe internal data​

SELECT  [table_name],
        [column_name],
        [constraint_name],
        [referenced_column_name],
        [referenced_table_name]
FROM information_schema.key_column_usage;

and it will show table_name, column_name, constraint_name, referenced_column_name, referenced_table_name from the table information_schema.key_column_usage

Describe Internal data from 1 table​

SELECT  table_name, column_name, constraint_name,
        referenced_column_name, referenced_table_name
FROM information_schema.key_column_usage
WHERE table_name = 'lab_emp'

this will show the constraint that is in the table of lab_emp