达梦数据库常用sql
ALTER TABLE ROOT.FW ADD SHZT NUMBER(2,0) default 1 ;
comment on column FW.SHZT is '审核状态';
ALTER TABLE ROOT.FW DROP COLUMN SHZT_TEXT;
ALTER TABLE ROOT.FW ADD SHZT_TEXT VARCHAR2(50) default '未审核' ;
comment on column FW.SHZT_TEXT is '审核状态';
SELECT * FROM oa_jbdt WHERE id IN ( SELECT id FROM oa_jbdt GROUP BY id HAVING COUNT(id) > 1
alter table G_USBKEY modify APPLYFORRIGHT_TEXT varchar2(80)
alter table g_gw modify sxfw varchar2(1000)
-- 达梦数据库修改字段长度
alter table OA_ZCSQ modify LXDH number(16,2);
alter table G_GW modify CRETE_TIME TIMESTAMP;
ALTER TABLE lw DROP COLUMN CBZT_TEXT;