Home » SQL & PL/SQL » SQL & PL/SQL » Print all Columns and tables (oracle 7, sql navigator)
Print all Columns and tables [message #357056] Mon, 03 November 2008 13:16 Go to next message
da1uwant2meet
Messages: 13
Registered: October 2008
Location: texax
Junior Member
Hello All,

Im fairly new to the wonderful world of Oracle...at my current position I sometimes have to create a script to find the data I am looking for...I want to make an entity relationship diagram and I wanted to know if there was a script that I could write that would show me all of the tables and the columns of my data...Right now Im in sql navigator and I am looking threw the schema and writing them down that way...But we have sooooooo many tables and doing this by hand would take alot of time...Any suggestions..
Re: Print all Columns and tables [message #357057 is a reply to message #357056] Mon, 03 November 2008 13:27 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@da1uwant2meet,

One way is to query ALL_TAB_COLUMNS View
Also search for DBA_TAB_COLUMNS or USER_TAB_COLUMNS. This has been asked here many times.

Hope this helps.

Regards,
Jo
Re: Print all Columns and tables [message #357058 is a reply to message #357056] Mon, 03 November 2008 13:33 Go to previous message
da1uwant2meet
Messages: 13
Registered: October 2008
Location: texax
Junior Member
Thank you...I used select table_name, column_name from user_tab_columns and it showed them all...Thanks again Surprised
Previous Topic: Page Not Find Error
Next Topic: Tables not updating... even after commit.
Goto Forum:
  


Current Time: Sat Feb 15 12:17:11 CST 2025