How to retrive datatables From Database

[lavankumar]

I had two hundered tables in database. I want to retrive the tables with one common field.How to does this .I Want use C# and Sql .I had different Tonnage in all the tables. if i want to call 300 tonnage in that all the tables(200 tables).How to retrive it from the datatable in the database. thank's in adv lavan

[Satish32]

if you are using oracle the following query can be used to retrieve the table names based on the column-name select * from dba_tab_columns where lower(owner) = 'order_schema' and lower(column_name) like '%column-name%'

Satish