Posted by Madhivanan on 07/11/06 14:44

Select table_name from information_Schema.columns where
column_name='column name'

Madhivanan


Sashi wrote:
> All, is there a way of getting all table names that contain a column
> name?
> I'm looking at a DB that has 125+ tables and I'm interested in finding
> all table names that contain the column order_date.
> How can I do it?
> TIA,
> Sashi

[Back to original message]