分享一下Oracle的建表语句吧
-- Create table
create table --表名
(
*** VARCHAR2(100),
*** NUMBER(20)
)
tablespace ***
pctfree 10
initrans 20
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table --表名
is '';
-- Add comments to the columns
comment on column --表名.字段名
is '';
-- Create/Recreate primary, unique and foreign key constraints
alter table --表名
add constraint --表名_PK primary key (--主键字段名)
using index
tablespace ***
pctfree 10
initrans 20
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create unique index --表名_U1 on 表名 (字段名1,字段名2)
tablespace ***
pctfree 10
initrans 20
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
--普通索引
create index --表名_N1 on 表名 (字段名1,字段名2)
tablespace ***
pctfree 10
initrans 20
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create sequence
create sequence --表_CID_S
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create sequence
create sequence --表名_S
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
insert into mt_sys_sequence values('table_name_cid_s',1,'table_name_cid_s');
insert into mt_sys_sequence values('table_name_s',1,'table_name_s');