oracle 建表sql语句

时间:2021-07-07 21:44:13

oracle 建表sql语句 ,ID为自增主键

///////////////////////////////////
create table T_WAREHOUSE(  id                 NUMBER,  serial_num         VARCHAR2(20),  name               VARCHAR2(20),  fk_bigwarehouse_id NUMBER,  warehousetype      VARCHAR2(20));-- Add comments to the table comment on table T_WAREHOUSE  is '仓库';-- Add comments to the columns comment on column T_WAREHOUSE.id  is '主键';comment on column T_WAREHOUSE.serial_num  is '仓库编号';comment on column T_WAREHOUSE.name  is '仓库名称';comment on column T_WAREHOUSE.fk_bigwarehouse_id  is '大仓库外键编号';comment on column T_WAREHOUSE.warehousetype  is '仓库类型(字典表)';--主键ALTER TABLE T_WAREHOUSE ADD CONSTRAINT PK_T_WAREHOUSE PRIMARY KEY (ID);--自增序列  seq开头create sequence SEQ_T_WAREHOUSEminvalue 1maxvalue 9999999999999999999start with 1increment by 1cache 20;--触发器  TG开头CREATE OR REPLACE TRIGGER TG_T_WAREHOUSE BEFOREinsert ON  T_WAREHOUSE FOR EACH ROWbegin  select SEQ_T_WAREHOUSE.nextval into:New.ID from dual;end;