select b.name from syscolumns a join sysobjects b on a.id=b.id where a.name='vflowid' --取出含有vflowid列从全部表名
select distinct b.name from syscolumns a join sysobjects b on a.id=b.id where a.name='vflowid' and b.xtype='U' and b.status>0 --查詢用戶表
select 表名=a.name ,case when b.id is null then '没有字段 [vflowid]' else '有字段 [vflowid]' end from sysobjects a left join syscolumns b on a.id=b.id and b.name='vflowid' where a.xtype='U' and a.status>=0
from syscolumns a join sysobjects b
on a.id=b.id
where a.name='vflowid'
--取出含有vflowid列从全部表名
from syscolumns a join sysobjects b
on a.id=b.id
where a.name='vflowid' and b.xtype='U' and b.status>0 --查詢用戶表
select 表名=a.name
,case when b.id is null then '没有字段 [vflowid]' else '有字段 [vflowid]' end
from sysobjects a
left join syscolumns b on a.id=b.id and b.name='vflowid'
where a.xtype='U' and a.status>=0