问题描述
是否有任何复杂或简单的方法可以获取数据库中现有完整模式的图形表示?我会尝试更具体一点:
Is there any way, complex or simple, to get a graphical representation for an existing full schema on my DB? I'll try to be more specific:
我已经在Oracle 11g上定义了一个架构，包括它的关系，外键和主键，序列以及您可能想到的所有内容.问题在于，有人忘记创建示意图，因此世界其他地方可以了解其中发生的事情.
I already have a defined schema on Oracle 11g, with its relationships, foreign and primary keys, sequences and all the stuff you might imagine. The problem is that someone forgot to create a schematic image so the rest of the world could understand what is happening in there..
因此，如果您某种程度上知道任何程序，那么只要给定Schema的DDL就可以为我提供数据库的关系和图形表示，我将不胜感激！
So if you knew someway, any program, that given a DDL of an Schema gives me a relational and graphic representation of my database i would be very grateful!
提前谢谢！
推荐答案
您可以在sqldeveloper中使用Data Modeler选项为数据库生成ER图.
You can use the Data Modeler option in sqldeveloper to generate the ER diagram for your DB.
http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
这篇关于Oracle 11g数据库的图形的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！