创建表
CREATE TABLE biaoming
(
ziduan1 NVARCHAR2(50) NOT NULL
, ziduan3 NVARCHAR2(20)
, ziduan2 NVARCHAR2(80)
)
给用户权限 insert update delete……
grant insert on biaoming to userid;
创建字段
alter table biaoming add ziduanming varchar2(
255
);
修改字段类型
alter table biaoming modify ziduanming NVARCHAR2(80)
修改字段名:
alter table 表名 rename column 列名 to 新列名;
alter table biaoming rename column ziduan to xinziduan;
删除字段:
alter table 表名 drop column 字段名;
alter table biaoming drop column ziduan;