Posted on 2013-11-29 21:21
ZT文萃 閱讀(256)
評論(0) 編輯 收藏 所屬分類:
后臺
ALTER TABLE TBNAME ADD COLUMN COLUMNNAME COLUMNTYPE COLUMNDEFAULTVALUE VALUE;
EG:
ALTER TABLE CIBCMS. T_TOL_CUST_VALIDADDR ADD COLUMN NVIPCORE_CFM_CNT BIGINT DEFAULT 0;
給表添加說明：
COMMENT ON COLUMN CIBCMS.T_TOL_CUST_VALIDADDR.NVIPCORE_CFM_CNT IS '已確認非VIP核心客戶數量'
ALTER TABLE TBNAME DROPE COLUMN COLUMNNAME;