Hi everybody

I am new to SQL and would be pleased if any one can help me out...
thank

What query should i used to get a list of table currently available in the database.

In Oracle you'd - if you're owner of the schema - issue
SELECT * FROM TAB;

To view all tables in your database, connect as a user with system privileges and try
SELECT * FROM ALL_TABLES;

If your server supports the INFORMATION_SCHEMA views, those would be my first suggestion. They are database engine agnostic, and implemented by almost all of the major vendors.

If it doesn't, can you tell us which engine you are using (Db2, MS-SQL, MySQL, Oracle, etc) so we can concoct the appropriate engine specific SQL for you?

-PatP