sp_msforeachtable 'if exists(select 1 from sysobjects a inner join syscolumns b on a.id=b.id where a.id=object_id(''?'') and b.name=''id'') select ''?'''
SELECT OBJECT_NAME(id) AS TableName FROM dbo.syscolumns WHERE name = 'ID' AND STATUS > 0
or select a.name from sysobjects a inner join syscolumns b on a.id=b.id where b.name='id' and a.xtype='u'
chuifengde 树上的鸟儿 等 级: 发表于:2007-10-16 14:59:486楼 得分:0 or select a.name from sysobjects a inner join syscolumns b on a.id=b.id where b.name= 'id ' and a.xtype= 'u ' -------------------------------- 这里的x.xtype='u'是指找那些表是吗?
GEPIN 极品 等 级: 发表于:2007-10-16 14:59:015楼 得分:0 SQL code SELECT OBJECT_NAME(id) AS TableName FROM dbo.syscolumns WHERE name = 'ID' AND STATUS > 0
select ''?'''
SELECT
OBJECT_NAME(id) AS TableName
FROM dbo.syscolumns
WHERE name = 'ID'
AND STATUS > 0
select a.name from sysobjects a inner join syscolumns b on a.id=b.id where b.name='id' and a.xtype='u'
树上的鸟儿
等 级:
发表于:2007-10-16 14:59:486楼 得分:0
or
select a.name from sysobjects a inner join syscolumns b on a.id=b.id where b.name= 'id ' and a.xtype= 'u '
--------------------------------
这里的x.xtype='u'是指找那些表是吗?
极品
等 级:
发表于:2007-10-16 14:59:015楼 得分:0
SQL code
SELECT
OBJECT_NAME(id) AS TableName
FROM dbo.syscolumns
WHERE name = 'ID'
AND STATUS > 0
---------------------------
想问一下这里的Status>0是什么意思呢?