SELECT * FROM `KEY_COLUMN_USAGE`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
def | mysql | PRIMARY | def | mysql | columns_priv | Host | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | Db | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | User | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | Table_name | 4 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | Column_name | 5 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | component | component_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | db | Host | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | db | Db | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | db | User | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | default_roles | HOST | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | default_roles | USER | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | default_roles | DEFAULT_ROLE_HOST | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | default_roles | DEFAULT_ROLE_USER | 4 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | engine_cost | engine_name | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | engine_cost | device_type | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | engine_cost | cost_name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | func | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | global_grants | USER | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | global_grants | HOST | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | global_grants | PRIV | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | gtid_executed | source_uuid | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | gtid_executed | interval_start | 2 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_category | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_category | help_category_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_keyword | name | 1 | NULL | NULL | NULL | NULL |
|