Thursday, May 09, 2013

MySQL

when we want to use command line to monitor table's foreign key. I try a approach as the following.
use INFORMATION_SCHEMA;
select TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME,
REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME from KEY_COLUMN_USAGE;

No comments: