– 创建表
create table TBL_USER
(
userid INTEGER not null,
username NVARCHAR2(100),
age INT,
remark NVARCHAR2(2000)
)
ALTER TABLE TBL_USER RENAME TO TBL_USER2 –修改表名
ALTER TABLE TBL_USER2 RENAME COLUMN USERNAME TO UNAME –修改表列名
ALTER TABLE TBL_USER2 MODIFY UNAME NVARCHAR2(50) –修改字段类型
ALTER TABLE TBL_USER2 ADD ADDRESS NVARCHAR2(40) –添加表列
ALTER TABLE TBL_USER2 DROP COLUMN ADDRESS –删除表列