oracle

–建表 CREATE TABLE BBBB_TEST ( “GUID” NVARCHAR2(32) NOT NULL ENABLE, “TESTNAME” NVARCHAR2(100), “AGE” NVARCHAR2(12), PRIMARY KEY (“GUID”) )

–字段添加注释 comment on column BBBB_TEST.GUID is ‘主键’;

–修改字段长度 ALTER TABLE BBBB_TEST MODIFY (TESTNAME VARCHAR2(100));

–字段重命名 ALTER TABLE BBBB_TEST rename column TESTNAME to TESTNAME1

–删除字段 alter table BBBB_TEST drop column age1

–增加字段 alter table BBBB_TEST add (AGE VARCHAR2(12),SEX VARCHAR2(1))

–创建索引 CREATE INDEX “IDX_SHIPMENTGUID” ON TTINTERNALTRANSPORTORDERHEADER (STSHIPMENTGUID);

– 设置字段默认值 alter table 表名 modify 字段名 default 默认值;