开发者

How to find dependencies on a table in mysql 5.0?

开发者 https://www.devze.com 2023-03-31 01:32 出处:网络
I am trying to drop a table in MySQL but its complaining about \"Cannot delete or update a parent row: a foreign key constraint fails\"...

I am trying to drop a table in MySQL but its complaining about "Cannot delete or update a parent row: a foreign key constraint fails"...

Is there a way to find out all the table dependencies and objects dependent on it?

For sybase, DBArtisan g开发者_运维问答ives a really easy way to find dependecies. Is there any such tool for MySQL?


SHOW CREATE TABLE mytable;

It'll show you (along with some other stuff) the foreign key relationships for the table.

0

精彩评论

暂无评论...
验证码 换一张
取 消