Re: get tablenames

> I need a sql-query to get all tablenames of a scheme or user in a database.
> select * from tables;
> in mysql it's "showtables".

Look at user_tables, all_tables and dba_tables (depends on your permissions).

Regards,

Knut Received on Fri Apr 12 2002 - 08:43:17 CDT