Get Database's Tables

Question

Hi

I want to write a query to get the names of tables of a specific database, but I don't know how can write it.

I want to execute this query for MS Access 2007 and Oracle 11g.

Thanks

Answer 1

If you want raw, direct queries:

For Oracle:

SELECT * FROM user_tables

For MS Access:

SELECT * FROM  MSysObjects  WHERE [Type] In (1, 4, 6)

(sorting and advanced filtering omitted for brevity.)