A column name is given to you. You have to find out which table has that column. Database has 230 tables. For example: empid (column name) For this how do you find out which table has the column (empid) ?

Interview Candidate
Jul 11th, 2007
13
14470

Showing Answers 1 - 13 of 13 Answers

SDJ

Jul 13th, 2007

select sysobjects.name from sysobjects,syscolumns
where
sysobjects.id = syscolumns.id and
syscolumns.name like 'empid'

shamimaziz
Profile Answers by shamimaziz

Jul 21st, 2007

select name from sysobjects where type = 'U' and id = ( select id from syscolumns where name = 'empid')

Kapil Kumar

Aug 17th, 2007

You can use this query as well

Select Object_name(ID) from Syscolumns where Name = 'Coulmn Name'

Regards,
Kapil

nbeeram
Profile Answers by nbeeram

Apr 15th, 2009

By joining the system tables - syscolumns and sysobjects on the id column

nishusingh84
Profile Answers by nishusingh84

Oct 8th, 2009

SELECT DISTINCT o.name FROM sysobjects o,syscolumns c
WHERE o.id=c.id AND
c.name='empid' --- or you can go for c.name LIKE "%empid%"