–建表 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 默认值;