SELECT object_name
FROM user_objects
WHERE object_type in ('TABLE', 'VIEW')
This will get you the table and view names.
SELECT column_name
FROM user_tab_columns
WHERE table_name = 'your_table_name_here'
This will get you the columns for that particular table.
SELECT DISTINCT table_name, column_name
FROM user_tab_columns
ORDER BY 1,2
This will get you the table names with their associated column names.
HTH
-----Original Message-----
From: Robert Shaw [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 11:48 AM
To: CF-Talk
Subject: Get Database Tables, etc
I know I have seen this on the list before but I can't find the exact code.
Does anyone have the code for querying a database and returning a list of
tables and/or column info?
TIA,
Robbie
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
