获取指定库表的主外键字段

1. 获取指定表的主键字段

SELECT k.column_name pkeyFROM information_schema.table_constraints tJOIN information_schema.key_column_usage kUSING (constraint_name,table_schema,table_name)WHERE t.constraint_type='PRIMARY KEY'AND t.table_schema='db_name'AND t.table_name='table_name' ;

2. 获取指定表的外键字段

SELECT k.column_name fkeyFROM information_schema.table_constraints tJOIN information_schema.key_column_usage kUSING (constraint_name,table_schema,table_name)WHERE t.constraint_type='FOREIGN KEY'AND t.table_schema='db_name'AND t.table_name='table_name' ;