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

• Next in forum: Re: Get all table names with a given column name
• Prev in forum: Re: Problem with installing SQL Server
• Thread view: Re: Get all table names with a given column name

[Reply to this message]