create table语法:
column_name column_type [default value] [not null] [primary key] [unqiue] [,]
...
)
alter table语法:
drop table 语法:
-- 在Oracle中 [default value]必须放在最前边,其它约束顺序不限
column_name column_type [default value] [not null] [primary key] [unqiue] [,]
...
)
alter table语法:
1. 改表名
rename old_table_name to new_table_name;
2. 改列名
alter table table_name rename column old_column_name to new_column_name;
3. 改主/外键
alter table table_name drop constraint key_name cascade; -- 先删
alter table table_name add constraint key_name primary/foreign key (column1[, column2, ...]) -- 再加
4. 改列类型
alter table table_name modify column_name new_column_type; -- 注意:原列类型无须描述
5. 改Nullable
alter table table_name modify column_name null/not null;
6. 改默认值
alter table table_name modify column_name default new_default_value;
7. 列注释CUD
comments on column table_name.column_name is '[comment content]';
8. 增加列
alter table table_name add new_column_name column_type [not null] [default value] [primary key] [unqiue]
9. 删除列
alter table table_name drop column column_name;
drop table 语法:
drop table table_name;