oracle修改表名、列名、字段类型、添加表列、删除表列:
select * from mytable for update;
delete from mytable2;
select * from mytable2;
create table mytable2 as select t.user_id,t.name,t.dengji,t.admini from mytable t;--以一个名的数据创建并生成数据
alter table myTable2 add email varchar2(32) ;
alter table mytable modify email2 varchar2(32);
alter table myTable rename column email2 to email; --重新命名表名
alter table myTable rename column ID to user_id;----重新命名数据库表列名
alter table myTable2 rename to mytable; ---重新命名数据库表名
alter table mytable modify USER_ID varchar2(32);--修改表列的类型
alter table mytable2 drop column email;--删除表列
添加和删除表的约束--在创建表以后,只能添加和删除,不能修改
alter table emp1 add constaint emp1_sal_ck check(salary > 0)
alter table emp1 modify (salary not null)
alter table emp1 drop constaint emp1_sal_ck
alter table emp1 disable constraint emp1_email_uk;----使某一个约束失效:此约束还存在于表中,只是不起作用
alter table emp1 enable constraint emp1_email_uk;----使某一个约束激活:激活以后,此约束具有约束力
create table emp1(
employee_id number(8),
salary number(8),
--列级约束
hire_date date not null,
dept_id number(8),
email varchar2(8) constraint emp1_email_uk unique,
name varchar2(8) constaint emp1_name_uu not null,
first_name varchar2(8),
--表级约束
constraint emp1_emp_id_pk primary key(employee_id),
constraint emp1_fir_name_uk unique(first_name),
constraint emp1_dept_id_fk foreign key(dept_id) references departments(department_id) ON DELETE CASCADE