Posted on 2013-11-29 21:21
ZT文萃 阅读(251)
评论(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;