I had a table as below
CREATE TABLE test ( id character varying(300) , name character varying(400) ); ALTER TABLE test ADD PRIMARY KEY (Id);
I had the following insert statements
insert into test(id,name)values('1','ram')`; insert into test(id,name)values('1','sam')`;
In the above insert statements i am trying to insert duplicate ‘id’. I am getting the error saying duplicate value the value already exits.
Is their any other way that we can declare a column as primary key and duplicate the primary key