Server: mysql wampserver »Database: information_schema »Table: KEY_COLUMN_USAGE
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.
Showing rows 0 - 24 (63 total, Query took 0.0434 sec)
SELECT * FROM `KEY_COLUMN_USAGE`
[ Inline ] [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh ]


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 NULLNULLNULLNULL
def mysql PRIMARY def mysql columns_priv Db 2 NULLNULLNULLNULL
def mysql PRIMARY def mysql columns_priv User 3 NULLNULLNULLNULL
def mysql PRIMARY def mysql columns_priv Table_name 4 NULLNULLNULLNULL
def mysql PRIMARY def mysql columns_priv Column_name 5 NULLNULLNULLNULL
def mysql PRIMARY def mysql db Host 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql db Db 2 NULLNULLNULLNULL
def mysql PRIMARY def mysql db User 3 NULLNULLNULLNULL
def mysql PRIMARY def mysql event db 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql event name 2 NULLNULLNULLNULL
def mysql PRIMARY def mysql func name 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql help_category help_category_id 1 NULLNULLNULLNULL
def mysql name def mysql help_category name 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql help_keyword help_keyword_id 1 NULLNULLNULLNULL
def mysql name def mysql help_keyword name 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql help_relation help_keyword_id 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql help_relation help_topic_id 2 NULLNULLNULLNULL
def mysql PRIMARY def mysql help_topic help_topic_id 1 NULLNULLNULLNULL
def mysql name def mysql help_topic name 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql innodb_index_stats database_name 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql innodb_index_stats table_name 2 NULLNULLNULLNULL
def mysql PRIMARY def mysql innodb_index_stats index_name 3 NULLNULLNULLNULL
def mysql PRIMARY def mysql innodb_index_stats stat_name 4 NULLNULLNULLNULL
def mysql PRIMARY def mysql innodb_table_stats database_name 1 NULLNULLNULLNULL
def mysql PRIMARY def mysql innodb_table_stats table_name 2 NULLNULLNULLNULL

Query results operations Print view Print view Print view (with full texts) Print view (with full texts) Export Export Display chart Display chart Create view Create view