开发者

Determining dependent tables in MySQL?

开发者 https://www.devze.com 2023-03-01 11:33 出处:网络
In MySQL, I need to know which tables depend on other tables. Is it possible to get the relations? In SQL Server it\'s possible to see dependent tables. I hope MySQL can do this too.

In MySQL, I need to know which tables depend on other tables. Is it possible to get the relations?

In SQL Server it's possible to see dependent tables. I hope MySQL can do this too.

If it's in pictorical form then that's e开发者_运维问答ven better.


Perhaps you want the SHOW CREATE TABLE command?

If there are foreign keys defined, the above command will show you what they are.


Take a look at the information_schema, especially to key_column_usage table.

http://dev.mysql.com/doc/refman/5.0/en/key-column-usage-table.html


Have a look at Database Explorer (object dependency tree) - a unique feature in dbForge Studio for MySQL. Easily explore object's references and dependants in Database Explorer. Compilation of dependants for debugging is now also available through the object's context menu.

Determining dependent tables in MySQL?

Also, Database Designer can show foreign key relations between tables.


maybe you'd want a graphical front-end to mysql since you're so used to SQL Server. if the foreign keys are defined, it will show up as a link between entities when you reverse engineer the database.

0

精彩评论

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

关注公众号