October 8, 2007 at 6:51 am
Comments posted to this topic are about the item Finding a particular column in All tables
November 6, 2008 at 6:22 am
or
select object_name(object_id) as table_name from sys.columns
where name='column_name' and objectproperty(object_id,'istable')=1
Failing to plan is Planning to fail
November 6, 2008 at 6:39 am
try like:
select*
fromINFORMATION_SCHEMA.COLUMNS
whereCOLUMN_NAME = 'your column name'
go
November 7, 2008 at 12:42 am
Kishore.P (11/6/2008)
try like:select*
fromINFORMATION_SCHEMA.COLUMNS
whereCOLUMN_NAME = 'your column name'
go
It would return View also
Failing to plan is Planning to fail
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply