国产成人精品亚洲777人妖,欧美日韩精品一区视频,最新亚洲国产,国产乱码精品一区二区亚洲

您的位置:首頁技術文章
文章詳情頁

Oracle入門——SQL查看CHECK約束信息

瀏覽:153日期:2023-11-21 15:34:06
以下兩個語句均基于系統表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 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.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 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 數據庫
主站蜘蛛池模板: 中卫市| 当涂县| 大邑县| 余庆县| 班玛县| 曲麻莱县| 长垣县| 筠连县| 青冈县| 夏邑县| 治多县| 甘孜| 玛沁县| 马山县| 湟中县| 阿合奇县| 东海县| 奉化市| 安丘市| 东乌珠穆沁旗| 汝阳县| 宿州市| 肇东市| 通辽市| 霸州市| 楚雄市| 金门县| 景谷| 平江县| 曲沃县| 开阳县| 子洲县| 徐闻县| 清镇市| 崇明县| 舒兰市| 册亨县| 新密市| 延寿县| 郓城县| 句容市|