目录
用 [TOC]
来生成目录:
qw
添加列>alter table table_name add column_name varchar2(10)
添加多列>alter table table_name
add (column_name varchar2(10),column_name varchar2(10)…)
删除列>alter table table_name drop column column_name
修改列>alter table table_name modify emp_telno number主键>alter table employee1 add constraint PK_empno
primary key(empno)
外键>alter table employee1 add constraint FK_deptno1
foreign key(deptno) references dept(deptno)