1.视图创建
视图的创建:create view 名称 as select 语句.
2.添加字段
alter table [table_name] add [column_name] [column_type]
3. 更改字段类型:
alter table [table_name] alter column [column_name] set data type [column_type]
4.去掉字段
alter table [table_name] drop column [column_name]
5.为字段添加默认值
alter table [table_name] alter column [column_name] set default [value]
6.添加带默认值的字段
alter table [table_name] add column [column_name] [column_type] not null with default [value]
7.设置字段默认时间为当前时间
alter table [table_name] alter column [column_name] set default current date;
8.重命名字段
alter table [table_name] rename column [column_name] to [new_column_name] ;
9.删除视图
drop view view_name
10.管理员赋予视图权限
GRANT CREATE VIEW TO tarena;