oracle创建表整形,oracle创建表

三个表item,product,orders,分别有主键 外键。另外创建了sequence让各表主键都自增，如：create itemid_sequence increment by 1 start by 1。以下是在PL/SQL下建立表后 自动生成的SQL。。。

-- Create table

create table ITEM

(

TYPEID VARCHAR2(14) not null,

TYPE   VARCHAR2(10)

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

-- Add comments to the table

comment on table ITEM

is '产品分类';

-- Add comments to the columns

comment on column ITEM.TYPEID

is '分类号';

comment on column ITEM.TYPE

is '分类名';

-- Create/Recreate primary, unique and foreign key constraints

alter table ITEM

add constraint PK_ITEM primary key (TYPEID)

using index

tablespace SYSTEM

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

——————————————

-- Create table

create table PRODUCT

(

PRODUCTID VARCHAR2(14) not null,

TITLE     VARCHAR2(10),

TYPEID    VARCHAR2(14) not null,

INFO      VARCHAR2(50),

PRICE     VARCHAR2(10)

)

tablespace SYSTEM

pctfree 10

pctused 40

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

-- Add comments to the table

comment on table PRODUCT

is '产品';

-- Create/Recreate primary, unique and foreign key constraints

alter table PRODUCT

add constraint PK_PRODUCT primary key (PRODUCTID)

using index

tablespace SYSTEM

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table PRODUCT

add constraint FK_PRODUCT foreign key (TYPEID)

references ITEM (TYPEID) on delete cascade;

——————————————

-- Create tablecreate table ORDERS(  ORDERID   VARCHAR2(14) not null,  NAME      VARCHAR2(10),  ADDRESS   VARCHAR2(20),  TEL       VARCHAR2(16),  EMAIL     VARCHAR2(30),  BTIME     DATE,  PRODUCTID VARCHAR2(14) not null)tablespace SYSTEM  pctfree 10  pctused 40  initrans 1  maxtrans 255  storage  (    initial 64K    minextents 1    maxextents unlimited  );-- Add comments to the table comment on table ORDERS  is '订单';-- Create/Recreate primary, unique and foreign key constraints alter table ORDERS  add constraint PK_ORDERS primary key (ORDERID)  using index   tablespace SYSTEM  pctfree 10  initrans 2  maxtrans 255  storage  (    initial 64K    minextents 1    maxextents unlimited  );alter table ORDERS  add constraint FK_ORDERS foreign key (PRODUCTID)  references PRODUCT (PRODUCTID) on delete cascade;