sqlserver 系统表的常见用法

1. sqlserver查询某个字段在哪些表中存在

SELECT b.name as TableName,a.name as columnname
From syscolumns a
INNER JOIN sysobjects b ON a.id=b.id
where b.type='U'
AND a.name='列名'