SQL修改

增加列：ALTER TABLE HERB_ORDER_DETAIL ADD MEDICAL_INSURANCE_TYPE VARCHAR2(10);COMMENT ON COLUMN HERB_ORDER_DETAIL.MEDICAL_INSURANCE_TYPE IS ‘医保类型‘;

调整字段长度：ALTER TABLE DOCTOR_ORDERS MODIFY MEMO VARCHAR2(4000);

SQL修改

标签：cto   har   tab   tor   erb   detail   varchar   comm   调整