Query to list all tables containing a column

Madhu.B.Rokkam
Posted by Madhu.B.Rokkam under Sql Server category on | Points: 40 | Views : 774
Create procedure sp_helpCol(
@columnName varchar(50)
)
as
select object_name(id) 'Table list where this column is used/exist'
from syscolumns where name = @columnName

Comments or Responses

Login to post response