Sometimes you want to see which tables in a database reference a particular column. Here is a script that will show you these.
select a.name
from sys.objects a
inner join sys.columns b
on a.object_id = b.object_id
where b.name = 'ownerid'
and a.type = 'u'
order by a.name
If you change the "type" to 'V' it will show you the views that reference that column, in case you want to make changes of this sort.
SQL allows access to its metadata via the sys. objects so hopefully this makes it easier for you to do maintenance.
