Oracle建表不设主键,oracle建表，设置主键，修改属性等

--建表

create table book(

book_id number(10),

book_name varchar2(20),

book_price number(10,2),

book_author varchar2(20),

book_publish_time date,

book_introduction varchar2(100)

);

--设置主键 constraint :约束

alter table book add constraint PK_ID primary key (book_id);

--添加和删除列

alter table book add book_remark varchar2(20);

alter table book add(

book_ext1 varchar2(20),

book_ext2 varchar2(20)

);

alter table book drop column book_ext1;

--修改表名称

alter table book rename to new_book;

alter table new_book rename to book;

--修改列名称

alter table book rename column book_name to book_name_new;

alter table book rename column book_name_new to book_name ;

--修改字段属性类型

alter table book modify book_name varchar2(40);

--修改字段属性默认值

alter table b