查找主键
select constraint_name from user_constraints where table_name = ''
查找主键字段
select columm_name from user_cons_columns where table_name = ''
and constraint_name = 'Pk_ '
select constraint_name from user_constraints where table_name = ''
查找主键字段
select columm_name from user_cons_columns where table_name = ''
and constraint_name = 'Pk_ '
SELECT CONSTRAINT_NAME FROM ALL_CONSTRAINTS;
SELECT CONSTRAINT_NAME FROM DBA_CONSTRAINTS;
AND constraint_name = ( select constraint_name
from user_constraints where table_name = TABLE_NAME and constraint_type = 'P')
SELECT * FROM USER_CONSTRAINTS where table_name = 'QDEA' AND CONSTRAINT_TYPE = 'P'
名称 空? 类型
----------------------------------------- -------- --------------
OWNER NOT NULL VARCHAR2(30) --用户名
CONSTRAINT_NAME NOT NULL VARCHAR2(30) --约束名
CONSTRAINT_TYPE VARCHAR2(1) --约束类型
TABLE_NAME NOT NULL VARCHAR2(30) --表名
SEARCH_CONDITION LONG --
R_OWNER VARCHAR2(30) --
R_CONSTRAINT_NAME VARCHAR2(30) --
DELETE_RULE VARCHAR2(9) --
STATUS VARCHAR2(8) --状态
DEFERRABLE VARCHAR2(14) --
DEFERRED VARCHAR2(9) --
VALIDATED VARCHAR2(13) --
GENERATED VARCHAR2(14) --
BAD VARCHAR2(3) --
RELY VARCHAR2(4) --
LAST_CHANGE DATE --最后更改时间
SYS_C001701,类型为check
约束条件定义为:EID
请问SYS_C001701怎样理解?
已连接。
SQL> DROP TABLE T_TEST;表已丢弃。SQL> CREATE TABLE T_TEST
2 (
3 ID VARCHAR2(10) PRIMARY KEY,
4 NAME VARCHAR2(20)
5 );表已创建。SQL> SELECT CONSTRAINT_NAME
2 FROM SYS.ALL_CONSTRAINTS
3 WHERE TABLE_NAME = 'T_TEST'
4 AND OWNER = 'PLAIN'
5 AND CONSTRAINT_TYPE = 'P';CONSTRAINT_NAME
------------------------------
SYS_C006542SQL>