La sélection courante ne contient pas de colonne unique. Les grilles d'édition, les cases à cocher ainsi que les liens Éditer, Copier et Supprimer ne sont pas disponibles.
Affichage des lignes 0 - ...
Cette vue contient au moins ce nombre de lignes. Merci de se référer à documentation. (traitement en 0,1006 seconde(s).) [TABLE_CATALOG: DEF... - DEF...]
SELECT * FROM `KEY_COLUMN_USAGE` ORDER BY `TABLE_CATALOG` ASC
| Filtrer les lignes: |
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG 1
| TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__tracking | db_name | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | languages | id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | time_zone_transition_type | Time_zone_id | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | product_quotation | id | 1 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__favorite | username | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | billers | id | 1 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__table_coords | db_name | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | expenses | id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | tables_priv | Table_name | 4 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | payment_with_paypal | id | 1 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | db_name | def | phpmyadmin | pma__column_info | db_name | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | quotations | id | 1 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__recent | username | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | deliveries | id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | proc | db | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | tables_priv | Host | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | func | name | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | sales | id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | index_stats | prefix_arity | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | proxies_priv | Host | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | column_stats | db_name | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | name | def | mysql | help_keyword | name | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | warehouses | id | 1 | NULL | NULL | NULL | NULL | |
| def | sprotest | PRIMARY | def | sprotest | departments | id | 1 | NULL | NULL | NULL | NULL | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__tracking | table_name | 2 | NULL | NULL | NULL | NULL |
| Filtrer les lignes: |