Finding Column,Table in Database for Data

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  May 13, 2010 at 4:40 am

  #221477

  hi All,

  I need to find table name from the Database.

  Suppose my DB is Employee with huge tables.

  I want know which table contains the data 'Language Multiple Selected'.

  Expected REsult:-

  Table Column

  EmpLanguage LangSelection

  Thanks in advance

  Pulivarthi

• Perry Whittle

  SSC Guru

  Points: 233914

  More actions

  May 13, 2010 at 5:33 am

  #1166774

  something along the lines of the following should work

  use yourdb

  select t.name as TableName, c.name as ColumnName from sys.tables t

  inner join sys.columns c on t.object_id = c.object_id

  where c.name = 'Yourcolumnname'

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉