PearlJamFanatic
asked on
get all table names for a given schema
need sql for to retrieve the informationf rom sybase 12.5, sybase 15 and oracle 11g databases.
The name of the schema is 'abcdefg'.
The information i need is available in TOAD. Schema browser--->select the schema 'abcdefg' from the list box on top--->the tables of this schema ar listed in the 'table' panel on the left.
the sql query should return the same list of table that is visible through toad.
already tried
SELECT table_name FROM user_tables
SELECT table_name FROM all_tables
select * from tabs
select * from abcdefg.ALL_TABLES
The name of the schema is 'abcdefg'.
The information i need is available in TOAD. Schema browser--->select the schema 'abcdefg' from the list box on top--->the tables of this schema ar listed in the 'table' panel on the left.
the sql query should return the same list of table that is visible through toad.
already tried
SELECT table_name FROM user_tables
SELECT table_name FROM all_tables
select * from tabs
select * from abcdefg.ALL_TABLES
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
FROM all_tables where owner='abcdefg' worked for me.