6,129
社区成员
发帖
与我相关
我的任务
分享
--适用于sql server 2005及以后的版本
SELECT DISTINCT t.name
FROM sys.tables t
INNER JOIN sys.columns c
ON t.object_id = c.object_id
WHERE c.name LIKE 'test%'
AND t.type = 'U'
--适用于sql server 2000
SELECT DISTINCT t.name
FROM sysobjects t
INNER JOIN syscolumns c
ON t.id = c.id
WHERE c.name LIKE 'test%'
AND t.xtype = 'U'
SELECT tablename = a.NAME, fieldname=MIN(b.NAME)
FROM sys.tables a
INNER JOIN sys.columns b
ON a.object_id = b.object_id
WHERE b.name LIKE '%test%'
GROUP BY a.name
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='test' -->具体到字段用等号
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%'