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);

posted @ 2017-12-01 18:15  发福大叔  阅读(140)  评论(0编辑  收藏  举报