建表时:
create table student(
id int primary key, //主键
name varchar);
每个表只能有一个主键,但是可以是多个属性组成联合主键,但只能是在表级上定义
语句如下:
primary key (name,sno);
create table class(
id int,
grade int,
foreign key (id) references student(id)); //外键
建表后添加主键外键:
alter table student
add primary key (id); //主键
alter table class
add foreign key (id) references student (id);
删除:
alter table student drop primary key;
alter table class drop foreign key (id);