
复制
createtable t(i number,管理
v mubmer notnull)
createtable t(i number,v mubmer
unique)
createtable t(i number
constraint pk_i
primarykey,v number)
createtable t2(c number,d number,
constraint fk_d
foreignkey(c),
references t1(v));
altertable t
addconstraint pk_i
primarykey (i)
altertable t
modify i notnull;
altertable t
addconstraint t_i
unique(i)[(
createindex ind_name
on t(i))];
altertable t
addconstraint t_i
check(i in (1,2,3,4,5));
altertable t disable novalidate
constraint i
altertable t enable novalidate
constraint check_i
altertable t
dropconstraint i;
altertable t
dropprimarykey i; 1.2.3.4.5.6.7.8.9.10.11.12.
(责任编辑:人工智能)