1、向现有表添加字段
alter table sch_schoolextinfo add (LASTYEARTHEQUALITY VARCHAR2(10));
alter table sch_schoolextinfo add (THEORYTRAINCOMNUM VARCHAR2(10));
2、添加注释
comment on column SCH_SCHOOLEXTINFO.LASTYEARTHEQUALITY is '上年度质量信誉考核情况';
SCH_SCHOOLEXTINFO -------> 表名字
LASTYEARTHEQUALITY --------> 字段名