Provided you are using MySQL 5.1 or later, you can use REFERENTIAL_CONSTRAINTS table from information schema Something like: select references_table_name from referential_constraints where table_name = 'your_table.
Provided you are using MySQL 5.1 or later, you can use REFERENTIAL_CONSTRAINTS table from information schema. Something like: select references_table_name from referential_constraints where table_name = 'your_table.
Select referenced_table_name, referenced_column_name from information_schema. Key_column_usage where table_name = 'Yourtable' and column_name='id.
SELECT CONSTRAINT_NAME, ORDINAL_POSITION, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME FROM information_schema. KEY_COLUMN_USAGE WHERE TABLE_NAME = 'table_name' AND TABLE_SCHEMA = 'database_name' AND REFERENCED_TABLE_SCHEMA = 'database_name'; ORDINAL_POSITION may be of interest when you have composite keys.
The alter statement doesn't know how to extrapolate the results from your select into multiple executions of drop foreign key. I execute the above query which will build all the alter statements for me. I then take that list of alter statements and run them manually.
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.