添加字段:
ALTER TABLE TABLE_NAME ADD COLUMN_NAME COLUMN_TYPE;
如:
alter table STUDENT add PATCH_ID NUMBER(6);
添加表注释:
COMMENT ON TABLE TABLE_NAME IS '注释信息'
如:
comment on table STUDENT is '学生信息表';
添加字段注释:
COMMENT ON COLUMN TABLE_NAME.COLUMN_NAME IS '注释信息'
如:
comment on column STUDENT.NAME is '姓名';