Oracle修改表结构(修改表名 字段名 字段类型)

--建表create table STUDENT(ID NUMBER(20),NAME VARCHAR2(20),SEX VARCHAR2(3));INSERT INTO STUDENT (ID, NAME, SEX) VALUES (1, 'LI', '女');INSERT INTO STUDENT (ID, NAME, SEX) VALUES (2, 'ZHAO', '男');INSERT INTO STUDENT (ID, NAME, SEX) VALUES (3, 'Tom', '男');COMMIT ;

1.修改表名

--将student修改成STUDENTSALTER TABLE STUDENT RENAME TO STUDENTS;--将students修改成studentALTER TABLE STUDENTS RENAME TO STUDENT;

2.修改字段名

--将字段name修改成namesALTER TABLE STUDENT RENAME COLUMN NAME TO NAMES;

3.修改数据类型

--将字段sex修改成char类型ALTER TABLE STUDENT MODIFY SEX CHAR(3);

4.增加age字段

ALTER TABLE STUDENT ADD AGE NUMBER;

5.删除age字段

ALTER TABLE STUDENT DROP COLUMN AGE;