修改表名:ALTER TABLE TESTold RENAME TO TESTNEW ;修改表列名ALTER TABLE TESTTABLE RENAME COLUMN NAME TO NAME1 修改字段类型ALTER TABLE TESTTABLE MODIFY NAME1 NUMBER(20);添加表列:ALTER TABLE TESTTABLE ADD ADD RESS VARCHA...
时光匆匆,记录是对思维的沉淀;
修改表名:ALTER TABLE TESTold RENAME TO TESTNEW ;修改表列名ALTER TABLE TESTTABLE RENAME COLUMN NAME TO NAME1 修改字段类型ALTER TABLE TESTTABLE MODIFY NAME1 NUMBER(20);添加表列:ALTER TABLE TESTTABLE ADD ADD RESS VARCHA...