Column to Search in DB

Hi, Can anyone help me by telling the sql statement through which I should b
e
able to locate the table which contains that ColumnName...
Thanks in Advance
KDKD,
Query Analyzer includes this capability and more with the Object Search
(F4).
HTH
Jerry
"KD" <KD@.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|||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" <KD@.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|||Thanks Hari, That's what I really wanted !
Thanks !
KD
"Hari Pra" 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" <KD@.discussions.microsoft.com> wrote in message
> news:B44D796D-7957-46BA-A5DE-337D6808A3A0@.microsoft.com...
>
>