明明已经把ck.sal删除了,并且select constraint_name,table_name,search_condition
2 from user_constraints
3 where owner='SCOTT';
CONSTRAINT_NAME TABLE_NAME SEARCH_CONDITION
------------------------------ --------------- --------------------
PK_DEPT DEPT
UN_ENAME EMP
PK_EMP EMP
FK_DEPTNO EMP
NOTNULLA XSA "ID" IS NOT NULL
BIN$2AlWV8Q3HFzgQKjABABm2A==$0 BIN$2AlWV8Q5HFz
gQKjABABm2A==$0SYS_C005414 SCOTT1
PK_E E
FK_E ECONSTRAINT_NAME TABLE_NAME SEARCH_CONDITION
------------------------------ --------------- --------------------
SYS_C005415 S
SYS_C005416 WED
也没有这个ck_sal,但创建时总说上面那句?
求解释
2 from user_constraints
3 where owner='SCOTT';
CONSTRAINT_NAME TABLE_NAME SEARCH_CONDITION
------------------------------ --------------- --------------------
PK_DEPT DEPT
UN_ENAME EMP
PK_EMP EMP
FK_DEPTNO EMP
NOTNULLA XSA "ID" IS NOT NULL
BIN$2AlWV8Q3HFzgQKjABABm2A==$0 BIN$2AlWV8Q5HFz
gQKjABABm2A==$0SYS_C005414 SCOTT1
PK_E E
FK_E ECONSTRAINT_NAME TABLE_NAME SEARCH_CONDITION
------------------------------ --------------- --------------------
SYS_C005415 S
SYS_C005416 WED
也没有这个ck_sal,但创建时总说上面那句?
求解释
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货