alter table table_name add constraint PK_table_name primary key(uid,pid)
添加主键约束
alter table table_name add constraint FK_table_name foreign key(pid) references table_name(pid)
添加外键
alter table table_name add constraint UQ_table_name unique(col_name)
alter table table_name add col_name col_type [ default ‘default_value’ ] NULL/NOT NULL
alter table table_name drop [ constraint ] constraint_name tip:delete is default item.
删除主键约束
alter table table_name drop column col_name