how to set a field primary key in a pre existing table
Hi,
Suppose i have a table and no field in it is a primary key like this
create table t1
(a number not null,
b number);
Later i want to make a as primary key then how to do that?
I tried with this statement but it gave error
alter table t1
modify a primary key;