|
Subject:
|
how to get all the tables from a database
|
|
Posted By:
|
rakeshgv
|
Post Date:
|
8/7/2006 5:51:35 AM
|
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
|
|
Reply By:
|
anujrathi
|
Reply Date:
|
8/7/2006 6:39:12 AM
|
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
|
|
Reply By:
|
rakeshgv
|
Reply Date:
|
8/8/2006 1:35:09 AM
|
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
|
|
Reply By:
|
prabhakaran
|
Reply Date:
|
12/1/2006 2:19:00 AM
|
hi try this statement
select *from inoformation_schema.tables
to get the tables information in current database
Thanks,
Prabhakaran
|
|
Reply By:
|
Jeff Moden
|
Reply Date:
|
12/1/2006 7:33:23 AM
|
Go to Enterprise Manager... right click on a table, select generate scripts, follow your nose.
--Jeff Moden
|
