SQL如何给列重命名？ – 网络|

ALTER TABLE TB_INFO ADD (CONTENT1 varchar2(20))

;//添加varchar2类型新列UPDATE TB_INFO SET CONTENT1=CONTENT; //将content列内容复制到content1列ALTER TABLE TB_INFO DROP COLUMN CONTENT;//删除varchar2类型列ALTER TABLE TB_INFO RENAME COLUMN CONTENT1 TO CONTENT;