Finding Column Name

prabhakaran · December 1st, 2006, 02:35 AM

Hi,
I have a database which contains 479 tables,I want to find a column in these table.
let say emp_id,i have to find this column in these tables.
how can we do that.
please help me

Thanks,
Prabhakaran

Jeff Moden · December 1st, 2006, 08:13 AM

One way would be to use [Tools][Object Search][New] in Query Analyzer.

So would this...

Code:

 SELECT so.Name AS TableName,
        sc.Name AS ColumnName
   FROM dbo.SysObjects so,
        dbo.SysColumns sc
  WHERE so.ID = sc.ID
    AND so.XType = 'U' --User table
    AND sc.Name = 'PutColNameHere'
  ORDER BY TableName

--Jeff Moden

prabhakaran · December 4th, 2006, 01:19 AM

Thanks a lot Jeff .T-SQL code works well..

Thanks,
Prabhakaran

Jeff Moden · December 4th, 2006, 09:36 AM

Thank you for the feedback.

--Jeff Moden