Re: How can we list all the tables in a database?
From: Jeff Boes <j.boes_at_zds.com>
Date: 1995/04/19
Message-ID: <3n37be$1f8h_at_cass.ma02.bull.com>#1/1
SHOW TABLE FOO (COLUMNS, INDEX, CONSTRAINT, TRIGGER) (you can guess)
I switched jobs from an Rdb shop to an Oracle shop about 8 months ago, and while I'd always heard how much more advanced Oracle was in its column functions, better performance, etc., I am amazed at how primitive its meta-data support is compared to Rdb and a few other products. Oracle, are you listening? Now that you've acquired Rdb as a product, perhaps you could RTFM on _it_ and see what you're missing?! Received on Wed Apr 19 1995 - 00:00:00 CEST
Date: 1995/04/19
Message-ID: <3n37be$1f8h_at_cass.ma02.bull.com>#1/1
I can't believe E A Macnaghten <ar02_at_dial.pipex.com> wrote:
>5603liul_at_vms.csd.mu.edu wrote:
>> How can I know what tables I have in my databases?
>SELECT TABLE_NAME FROM USER_TABLES for the current user's table
>SELECT OWNER, TABLE_NAME FROM ALL_TABLES for user's accessible tables
>SELECT OWNER, TABLE_NAME FROM SYS.DBA_TABLES (logged in as DBA) for
>all tables on database
And let me say how much I miss Rdb, which allowed:
SHOW TABLES (listed all tables) SHOW TABLE * (listed all columns in all tables)SHOW TABLE FOO (report of table FOO)
SHOW TABLE FOO (COLUMNS, INDEX, CONSTRAINT, TRIGGER) (you can guess)
I switched jobs from an Rdb shop to an Oracle shop about 8 months ago, and while I'd always heard how much more advanced Oracle was in its column functions, better performance, etc., I am amazed at how primitive its meta-data support is compared to Rdb and a few other products. Oracle, are you listening? Now that you've acquired Rdb as a product, perhaps you could RTFM on _it_ and see what you're missing?! Received on Wed Apr 19 1995 - 00:00:00 CEST