SQL查看CHECK约束信息
添加时间: 2008-4-28 22:57:47 作者: Oracle指导 阅读次数:47 来源: http://www.d9soft.com
1.SELECT TOP 100 PERCENT a.id AS tableid, a.tablename, a.colid, a.columnname,
a.datatype, a.length, b.constid AS checkid, b.checkname, b.status, b.content
FROM (SELECT sysobjects.name AS tablename, sysobjects.id,
syscolumns.name AS columnname, syscolumns.colid,
systypes.name AS datatype, syscolumns.length AS length
FROM sysobjects, syscolumns, systypes
WHERE sysobjects.xtype = ’u’ AND sysobjects.id = syscolumns.id AND
syscolumns.xtype = systypes.xtype AND
systypes.xtype = systypes.xusertype AND sysobjects.status > 0)
a LEFT OUTER JOIN
(SELECT sysobjects.name checkname, sysobjects.status, sysconstraints.constid,
sysconstraints.id, sysconstraints.colid, syscomments.text AS content
FROM sysobjects, sysconstraints, syscomments
WHERE xtype = ’c’ AND sysobjects.id = sysconstraints.constid AND
sysconstraints.constid = syscomments.id) b ON a.id = b.id AND
a.colid = b.colid
ORDER BY a.tablename, a.columnname, b.checkname
2.SELECT a.id AS tableid, a.tablename, b.constid AS checkid, b.checkname, b.status,
b.content
FROM (SELECT sysobjects.id, sysobjects.name AS tablename
FROM sysobjects
WHERE sysobjects.xtype = ’u’ AND sysobjects.status > 0) a LEFT OUTER JOIN
(SELECT sysobjects.name checkname, sysobjects.status, sysconstraints.constid,
sysconstraints.id, sysconstraints.colid, syscomments.text AS content
FROM sysobjects, sysconstraints, syscomments
WHERE xtype = ’c’ AND sysobjects.id = sysconstraints.constid AND
sysconstraints.constid = syscomments.id AND sysconstraints.colid = 0) b ON
a.id = b.id
上下文章:
上一篇文章: Oracle入门——起动和关闭详解 下一篇文章: 让window服务进程中自动加载MYSQL