Is it possible to determine the table linked to by a foreign key?

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.

Related Questions