Oracle 创建表与表别名创建

–复制表结构

create table newtable as select * from oldtable where 1<>1 

–建表

create table COMM.ORDERS_VALUATION_CONFIG
(
  serial_no        NUMBER(6),
  item_class  VARCHAR2(1)  not null,
  item_code   VARCHAR2(10),
  item_spec   VARCHAR2(8),
  units       VARCHAR2(8),
  grade       VARCHAR2(1) not null
)

–别名

Create public synonym ORDERS_VALUATION_CONFIG for COMM.ORDERS_VALUATION_CONFIG;

–添加注释

comment on column ORDERS_VALUATION_CONFIG.serial_no is '序号';
comment on column ORDERS_VALUATION_CONFIG.item_class is '类别';
comment on column ORDERS_VALUATION_CONFIG.item_code is '项目编码';
comment on column ORDERS_VALUATION_CONFIG.item_spec is '项目规格';
comment on column ORDERS_VALUATION_CONFIG.units is '单位';
comment on column ORDERS_VALUATION_CONFIG.grade is '等级(0:基础项目,1:整个类别)';

–添加主键

ALTER TABLE COMM.ORDERS_VALUATION_CONFIG ADD PRIMARY KEY (SERIAL_NO);

–加字段

alter  table students  add (starttime varchar2(8),endtime varchar2(8));

–修改

ALTER TABLE 表名 MODIFY 要修改的字段 VARCHAR2（12）;