Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Finding a particular column in All tables Expand / Collapse
Author
Message
Posted Monday, October 8, 2007 6:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 2:55 AM
Points: 142, Visits: 37
Comments posted to this topic are about the item Finding a particular column in All tables


Kindest Regards,

Sureshkumar Ramakrishnan

Post #407960
Posted Thursday, November 6, 2008 6:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 23, 2014 5:59 AM
Points: 329, Visits: 470
or

select object_name(object_id) as table_name from sys.columns
where name='column_name' and objectproperty(object_id,'istable')=1




Madhivanan

Failing to plan is Planning to fail
Post #598060
Posted Thursday, November 6, 2008 6:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:57 AM
Points: 1,391, Visits: 609
try like:

select *
from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME = 'your column name'
go



Post #598072
Posted Friday, November 7, 2008 12:42 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, May 23, 2014 5:59 AM
Points: 329, Visits: 470
Kishore.P (11/6/2008)
try like:

select *
from INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME = 'your column name'
go

It would return View also




Madhivanan

Failing to plan is Planning to fail
Post #598701
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse