KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Almost all the information I had needed about a database, I could find in information_schema This time I needed to read details of all foreign keys in a database through single query I found every thing in information_schema.key_Column_usage but could not find the constraints like on delete, on update I could do show create table for all individual tables. But is there any way to get these details through some select query like this? SELECT CONSTRAINT_NAME, TABLE_NAME,COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema.`KEY_COLUMN_USAGE` WHERE table_schema = 'mydbname' AND referenced_column_name IS NOT NULL It is doing the job well but just missing constraints like on delete, on update How can I get those values as well so that I can get all info about foreign keys in a single query?
Tags (comma-separated)
Save Edits
Cancel