[toc] ## 新增字段 ``` alter table hdbft.rpt_device_group add( BLNAME varchar2(20),FAMILYGROUP varchar2(20)) ``` ## 修改字段 ``` alter table fwassy.fwcatns_returndie modify (WMDUQTY varchar2(30)); ``` ## 建立索引 ``` create index SAPSR3.WIP_ACTIVITY_LOT_LINEID ON dcwip.wip_activity( Lot_ID,factory_line_id ) TABLESPACE B2BODS ``` ## 删除主键约束 ``` alter table FWASSY.FWCATNS_AOLOT drop constraint AOLOT_PK; ``` ## 删除列 ``` alter table emp4 drop column test; ```