Statement:

Rename column oldCName to newCName- modify field name

Alter table name modify (column name data type); -Modify the data type

For example:

1, create a table:

Create table students (

Id varchar2(32) primary key,

Name varchar2(8) is not empty.

Age figures

);

2. Modify the field name:

Alter table Student renamed the column name StuName.

3. Modify the data type:

alter table Student modify(id varchar 2(64))；

Do things when awake, read books when confused, sleep when angry, and think when alone; Be a happy person, study, travel, work hard, care about your body and mood, and do your best.