MSSQL查看数据库中所有包含某字段的表，表是否包含某字段

SELECT OBJECT_NAME(id) objName,
name AS colName
FROM syscolumns
WHERE (name LIKE ‘%要查询的字段名%’)
AND id IN (
SELECT id FROM sysobjects WHERE xtype = ‘u’
)
ORDER BY objName;

SELECT count(*) from information_schema.columns where table_name = ‘T_OrderBooks’ and column_name = ‘要查询的字段名’