Column to Search in DB

29 Sep 2005 4:34 PM

KD

Hi, Can anyone help me by telling the sql statement through which I should be
able to locate the table which contains that ColumnName....

Thanks in Advance
KD

29 Sep 2005 4:54 PM

Jerry Spivey

KD,

Query Analyzer includes this capability and more with the Object Search
(F4).

HTH

Jerry
Show quote

"KD" <K*@discussions.microsoft.com> wrote in message
news:B44D796D-7957-46BA-A5DE-337D6808A3A0@microsoft.com...
> Hi, Can anyone help me by telling the sql statement through which I should
> be
> able to locate the table which contains that ColumnName....
>
> Thanks in Advance
> KD

29 Sep 2005 7:02 PM

Hari Prasad

Hi,

Use the below query:-

select Table_name from information_schema.columns where
column_name='column_name'

You can also query the system table SYSCOLUMNS.

Thanks
Hari
SQL Server MVP

Show quote

"KD" <K*@discussions.microsoft.com> wrote in message
news:B44D796D-7957-46BA-A5DE-337D6808A3A0@microsoft.com...
> Hi, Can anyone help me by telling the sql statement through which I should
> be
> able to locate the table which contains that ColumnName....
>
> Thanks in Advance
> KD

29 Sep 2005 8:31 PM

KD

Thanks Hari, That's what I really wanted !

Thanks !
KD

Show quote

"Hari Prasad" wrote:

> Hi,
>
> Use the below query:-
>
> select Table_name from information_schema.columns where
> column_name='column_name'
>
> You can also query the system table SYSCOLUMNS.
>
> Thanks
> Hari
> SQL Server MVP
>
>
>
> "KD" <K*@discussions.microsoft.com> wrote in message
> news:B44D796D-7957-46BA-A5DE-337D6808A3A0@microsoft.com...
> > Hi, Can anyone help me by telling the sql statement through which I should
> > be
> > able to locate the table which contains that ColumnName....
> >
> > Thanks in Advance
> > KD
>
>
>