Oracle创建主键

创建主键方式

1.一个表的主键是唯一标识,不能有重复,不允许为空。
2.一个表的主键可以由一个字段或多个字段共同组成。

--    列级,表级建立主键
1.create table constraint_test
( name_id number not null constraint cons_name_id primary key,
 old number )
2.create table constraint_test
( name_id number  primary key,
 old number )


drop table constraint_test;
3.create table constraint_test
( 
name_id number not null,
old number  ,
constraint cons_name_id primary key ( name_id ) 
);


drop table constraint_test;


4.create table constraint_test
( 
name_id number not null,
old number   
);
alter table constraint_test add constraint cons_name_id primary key ( name_id );

外键

drop table course ;
drop table students ;
create table students
(code number  ,
name varchar2(10),
country varchar2(30)
);


alter table students add constraint pk_st_cod primary key ( code);
insert into students values(0001,zhangsan,shanghai);
insert into students values(0002,lisi,beijing);
insert into students values(0003,wangwu,guangzhou);


create table course 
(id number,
code  number,
name varchar2(10),
subject varchar2(30)
);
alter table course  add constraint pk_co_id primary key ( id);
alter table course  add constraint fk_co_st foreign key ( code) references  students(code);
alter table students add foreign key pk_co_id on id;
inser into course(id,code,name,subject) values(1,001,zhangsan,yuwen);
inser into course(id,code,name,subject) values(2,001,zhangsan,shuxue);

总结:如果要删除有外键的表,必须删除关联表数据

 

Oracle创建主键

上一篇:C#中,将生成的Guid转换成Oracle数据类型Raw(16)


下一篇:SHELL脚本执行mongodb 添加用户权限