display list of all tables in database

Thread Solved

Join Date: Sep 2008
Posts: 40
Reputation: cutedipti is an unknown quantity at this point 
Solved Threads: 0
cutedipti cutedipti is offline Offline
Light Poster

display list of all tables in database

 
0
  #1
Jul 9th, 2009
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.
Thanks & Regards
Ms. Dipti
Reply With Quote Quick reply to this message  
Join Date: Feb 2008
Posts: 12
Reputation: iceman29 is an unknown quantity at this point 
Solved Threads: 2
iceman29's Avatar
iceman29 iceman29 is offline Offline
Newbie Poster

Re: display list of all tables in database

 
0
  #2
Jul 9th, 2009
Hi Dipti,

You can use the below querry to get the table names in your DB:
  1. SELECT * FROM tab;
Learn to appreciate and appreciate to learn.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC