Hello Darian,
I tried with the query what you had suggested, but it
returned the Db Name and not the table name. 
Regards
Mallikarjuna
--- Darin Strait <dstrait@e...> wrote:
> Alternatively, try:
> select * from information_schema.columns where
> column_name = 'some_column'
> 
> MS has promised to keep that from breaking, going
> forward.
> 
> Darin Strait, MS SQL Server Development and
> Administration
>
http://home.earthlink.net/~dstrait/professional/resume.htm
> 
> 
> ----- Original Message -----
> From: "Fotopoulos, Lefteris" <LFot@e...>
> To: "sql language" <sql_language@p...>
> Sent: Tuesday, April 24, 2001 6:37 AM
> Subject: [sql_language] RE: SQL Column
> 
> 
> > Try this
> >
> > select name from sysobjects
> > where id in (select id from syscolumns where
> name='column_name') and
> > type='u'
> >
> > Lefteris
> >
> > -----Original Message-----
> > From: Mallikarjuna Chandrashekar
> [mailto:arjunshekar@y...]
> > Sent: Tuesday, April 24, 2001 7:04 AM
> > To: sql language
> > Subject: [sql_language] SQL Column
> >
> >
> > hello Everybody,
> >
> > can we write a Query which gets the
> > names of all the tables in a database
> > which contains particular Column
> >
> > Thanks in Advance
> > Regards
> > Mallikarjuna
> >
>