SELECT * FROM `KEY_COLUMN_USAGE`
Filtrer les lignes: |
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 | time_zone_leap_second | Transition_time | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_topic | help_topic_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_topic | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proc | db | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proc | name | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proc | type | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | time_zone_transition | Time_zone_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | time_zone_transition | Transition_time | 2 | 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_category | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_keyword | help_keyword_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_keyword | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_table_stats | database_name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_table_stats | table_name | 2 | 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 | Host | def | mysql | roles_mapping | Host | 1 | NULL | NULL | NULL | NULL | |
def | mysql | Host | def | mysql | roles_mapping | User | 2 | NULL | NULL | NULL | NULL | |
def | mysql | Host | def | mysql | roles_mapping | Role | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proxies_priv | Host | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proxies_priv | User | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proxies_priv | Proxied_host | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | proxies_priv | Proxied_user | 4 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | servers | Server_name | 1 | NULL | NULL | NULL | NULL |
Filtrer les lignes: |