Retrieve table list where the given column name exists

Madhu.b.rokkam
Posted by Madhu.b.rokkam under Sql Server category on | Points: 40 | Views : 1668
Select object_name from syscolumns where name = @yourColumnName

this query is very handy at times when we need to retrieve the list of tables where the given column name exits

Comments or Responses

Login to post response