3001 · SQL> alter table customer_detail add constraint customer_uk UNIQUE(CUSTOMER_ID, NAME);Alter table adding a PRIMARY KEY column You can also add a column to an existing table with PRIMARY KEY constraint only if the table is empty and if there is no PRIMARY KEY already existing in the table To add a column with PRIMARY KEY constraint, give the following command alter table emp add (EmpID varchar2() constraint emp_pk primary key); · Create a composite Primary key of the field and rowid function This will make every row unique Please remember the warning given above This will work if you are trying to make the primary key to speed up the performance, but if you are planning to do query or want to use the primary key as a constraint then it won't work out Foreign Key Oracle Foreign Key By Microsoft Awarded Mvp Oracle Tutorial Learn In 30sec Wikitechy Sql Tutorial Oracle alter table add primary key using index
