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 | StdMdDB | PRIMARY | def | StdMdDB | course | id | 1 | NULL | NULL | NULL | NULL | |
def | StdMdDB | PRIMARY | def | StdMdDB | student | id | 1 | NULL | NULL | NULL | NULL | |
def | StdMdDB | PRIMARY | def | StdMdDB | user | id | 1 | NULL | NULL | NULL | NULL | |
def | Stefano | PRIMARY | def | Stefano | vulcano | codice | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | RK | Id_speciale | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | RK | Id_saison | 2 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | RK | Id_pilote | 3 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_saison | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_voiture | 2 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_rallye | 3 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | cours | Id_pilote | 4 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | ecurie | Id_ecurie | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | pilote | Id_pilote | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | rallye | Id_rallye | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | speciale | Id_speciale | 1 | NULL | NULL | NULL | NULL | |
def | Table_insertion | PRIMARY | def | Table_insertion | voiture | Id_voiture | 1 | NULL | NULL | NULL | NULL | |
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 |
|