3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
Rotaxe 2003-12-18
select name from syscolumns c where exists (select * from syscomments m where c.colid=m.colid and id in(select id from sysobjects o where type='c' and c.id=o.parent_obj and name='约束名'))
Rotaxe 2003-12-18
select name from syscolumns c where exists (select colid from
sysindexkeys k WHERE k.colid=c.colid and k.id=c.id and exists (select id from sysindexes i where i.id=k.id and i.indid=k.indid and name='索引名'))
sysindexkeys k WHERE k.colid=c.colid and k.id=c.id and exists (select id from sysindexes i where i.id=k.id and i.indid=k.indid and name='索引名'))
dgcoo 2003-12-18
多谢仁兄