how to get all the tables from a database

Rakesh.G.V
Inetfarme Technologys,
732, 7th Cross, 11th Main Road,
BTM 2nd Stage
Bangalore 560 076, India
 
Phone :
+91-80-26787788
+91-80-26783615
 
Mobile:
9886322550

 http://www.inetframe.com

Hi Rakesh,
I can give u the solution but first of all, can u clear ur question ?
Wht u want ? From Which database do u want ?
U want to see all the tables present in any perticular database or u want to import them in dataset ? Pls always post full information !!!!

Regards,
Anuj Rathi

how to get all the tables from a single database(any database).Means i want to just get information of all the tables from a single database.

Rakesh.G.V
Inetfarme Technologys,
732, 7th Cross, 11th Main Road,
BTM 2nd Stage
Bangalore 560 076, India
 
Phone :
+91-80-26787788
+91-80-26783615
 
Mobile:
9886322550

 http://www.inetframe.com

hi try this statement
select *from inoformation_schema.tables
to get the tables information in current database

Thanks,
Prabhakaran

Go to Enterprise Manager... right click on a table, select generate scripts, follow your nose.

--Jeff Moden