欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 以下两个语句均基于系统表sysobjects、syscomments和系统视图sysconstraints，查询结果中包括表ID、表名、列ID、列名、CHECK约束ID、CHECK约束名、CHECK约束status值以及CHECK约束的内容，TCCView为欢迎进入oracle社区论坛，与200万技术人员互动交流 >>进入以下两个语句均基于系统表sysobjects、syscomments和系统视图sysconstraints，查询结果中包括表ID、表名、列ID、列名、CHECK约束ID、CHECK约束名、CHECK约束status值以及CHECK约束的内容，TCCView为Table-Column-Check View，结果中均为列级CHECK约束，TCView为Table-Check View，结果中均为表级CHECK约束。
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.contentFROM (SELECT sysobjects.name AS tablename, sysobjects.id,syscolumns.name AS columnname, syscolumns.colid,systypes.name AS datatype, syscolumns.length AS lengthFROM sysobjects, syscolumns, systypesWHERE sysobjects.xtype = 'u' AND sysobjects.id = syscolumns.id ANDsyscolumns.xtype = systypes.xtype ANDsystypes.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 contentFROM sysobjects, sysconstraints, syscommentsWHERE xtype = 'c' AND sysobjects.id = sysconstraints.constid ANDsysconstraints.constid = syscomments.id) b ON a.id = b.id ANDa.colid = b.colidORDER BY a.tablename, a.columnname, b.checkname 2.SELECT a.id AS tableid, a.tablename, b.constid AS checkid, b.checkname, b.status,b.contentFROM (SELECT sysobjects.id, sysobjects.name AS tablenameFROM sysobjectsWHERE 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 contentFROM sysobjects, sysconstraints, syscommentsWHERE xtype = 'c' AND sysobjects.id = sysconstraints.constid ANDsysconstraints.constid = syscomments.id AND sysconstraints.colid = 0) b ONa.id = b.id