开发者

Oracle Schema designer

I don't know the real name of that application but what i want to do is so simple, i have an oracle database with more than 50 tables. I want to get their names also their field names, so i thought that it would be nice to use a designer or something like mssql has. Then i can get 开发者_C百科the field names and table names easily. How can i do that?

Thanks for the help, Mehmet Şerif Tozlu


If by "getting table and field names" you mean, inside a program, you need to use Oracle's METADATA through any METADATA API you feel more comfortable with: JDBC, ADO.NET, ODBC, or even performing queries against METADATA tables (user_tables, all_tables, etc).

If by "getting table and field names" you mean a visual tool to inspect them, there are a lot of them.

  1. PL/SQL developer (My Favorite, by far: fast, useful. Unfortunately, runs only on Windows)
  2. Toad
  3. SQL Developer (Oracle's java based free programming tool)
  4. Enterprise Manager (Oracle's java based administering tool)
  5. ...

Hope it helps.


Instead of outputting all 50 tables and all columns all at once, what you may want to do is to generate several diagrams, each containing tables for a functional part of your system. In a hypothetical system, this could be "client and accounts", "bank transactions", and so on. Some tables may appear in multiple diagrams. Not all columns may need to be outputted, especially if they do not belong to a particular functional area of your system.

You can use SchemaCrawler for Oracle. SchemaCrawler allows you to search for and only output tables and columns that match a regular expression, as well as to generate database diagrams, with the help of GraphViz. It also find implied relationships between tables if the schema uses a naming convention.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜