Monday, May 15, 2006
How to get information about tables and table columns in Oracle?
Get all tables including the system ones:
SELECT table_name FROM all_tables;

That will give you only the tables owned by the user that you are connecting as:
SELECT table_name FROM user_tables;

Query table columns:
SELECT * FROM all_tab_cols WHERE table_name = 'whatever table name you are looking for'

Looking for comments on the tables:
SELECT * FROM all_tab_comments WHERE table_name = 'whatever table name you are looking for'
Oracle
5/15/2006 1:30:39 PM (Mitteleuropäische Sommerzeit , UTC+02:00)  #    Disclaimer  |  Comments [1]  | 
Related Posts:
The Better Blog
How do I add columns to table in Oracle
5/16/2006 1:35:25 PM (Mitteleuropäische Sommerzeit , UTC+02:00)
cool, just needed that!
Harry
Name
E-mail
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):