Oracle里對(duì)約束的增刪改

添加約束

SQL>alter table customer add constraint cardunique unique(cardId);

刪除約束

SQL>alter table customer drop constraint addresscheck;

在刪除主鍵的時(shí)候，必須帶上cascade選項(xiàng)

-
 
SQL>alter table customer primary key cascade;

添加主鍵

SQL>alter table customer add constraint pkkey primary key(customerId);

查看約束信息

SQL> select constraint_name,table_name,r_owner,r_constraint_name

2  from all_constraints where table_name='goods' and table_name='customer'

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]