Alter table to add primary key
SQL> SQL> create table emp ( 2 id number(6) ); Table created. SQL> SQL> alter table emp 2 add constraint emp_pk 3 primary key (id); Table altered. SQL> SQL> SQL> drop table emp; Table dropped.