MSSQL问题求救

[QQ308944476]

我想模糊匹配 字段。 例如 like一个 test 字段。把当前数据库所有包含test这个字段的所有表都列出来。




求高手指教。

[rtdb]

SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.Columns where COLUMN_NAME = 'test'

[Andy__Huang]

select b.name as 表名,a.name as 字段名 
from syscolumns a
inner join sysobjects b on a.id=b.id
where b.xtype='U' and a.name like '%test%'


select 'select * from '+b.name+ ' where '+a.name+' like ''%XXXX%'''
from syscolumns a
inner join sysobjects b on a.id=b.id
where b.xtype='U' and a.name='date1'