display list of all tables in database

[cutedipti]

Hi
I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database.
And for that i want to display all the tables created in database. As we can dispaly all the columns of a table by using
select * from table_name
So. please tell me such a query by which i can display list of all tables exists in my database.

[iceman29]

Hi Dipti,

You can use the below querry to get the table names in your DB:

select * from tab;