希希希望啊的博客

select * from all_tables where owner='KTMEDICALCENTER';select * from all_tables where owner='KTMEDICALCENTER';【注意】KTMEDICALCENTER是用户名，且必须是大写。

ALTER TABLE EXAM_LOG ADD AREA_TYPE VARCHAR2(20);COMMENT ON COLUMN EXAM_LOG.AREA_TYPE IS '区域类型';ALTER TABLE EXAM_LOG ADD AREA_TYPE VARCHAR2(20);COMMENT ON COLUMN EXAM_LOG.AREA_TYPE IS '区域类型';

alter table 表名 drop column 字段名(即列名);alter table exam_log drop column area_code;alter table exam_log drop column area_code;

ALTER TABLE 表名 MODIFY COLUMN 字段名 数据类型(修改后的长度)alter table EXAM_TEST modify STU_NAME VARCHAR2(100);alter table EXAM_TEST modify STU_NAME VARCHAR2(100);