-- 大表删除、修改某些字段以便添加默认字段能够顺利进行 DELETE FROM xwcmdbfieldinfo WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'planpubtime'; DELETE FROM xwcmviewfieldinfo WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'planpubtime'; DELETE FROM xwcmdbfieldinfo WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'CMyCrUser'; DELETE FROM xwcmviewfieldinfo WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'CMyCrUser'; DELETE FROM xwcmdbfieldinfo WHERE TABLENAME = 'GovInfo' AND FIELDNAME = 'STATUSFORBS'; DELETE FROM xwcmviewfieldinfo WHERE TABLENAME = 'GovInfo' AND DBFIELDNAME = 'STATUSFORBS'; alter table wcmmetatableGovInfo drop column planpubtime, drop column CMyCrUser, drop column STATUSFORBS