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;

[teja1989]

hi,

use below query to get all table names in database

SELECT TABLE_SCHEMA + '.' + TABLE_NAME, *
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_SCHEMA + '.' + TABLE_NAME

[mangal4mTerna]

select * from all_tables;