Oracle约束检验
SQL>>2/Table> SQL>
SQL>> 2 add constraint PK_TEST primary key (ID)
3 deferrable initially deferred
4 using index
5 tablespace Users
6 pctfree 10
7 initrans 2
8 maxtrans 255
9 storage
10 (
11 initial 64K
12 minextents 1
13 maxextents unlimited
14 );
Table> SQL> select CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME,DEFERRABLE,DEFERRED,VALIDATED from user_constraints
2/
CONSTRAINT_NAME CONSTRAINT_TYPE TABLE_NAME DEFERRABLE DEFERREDVALIDATED
------------------------------ --------------- ------------------------------ -------------- --------- -------------
PK_TEST P TEST DEFERRABLE DEFERREDVALIDATED
页:
[1]