On 23 November 2017 at 12:31, Brahmam Eswar <brahmam1...@gmail.com> wrote:
> Unable to add multiple keys to the table. > > ALTER TABLE table1 ADD CONSTRAINT Table1_PK PRIMARY KEY (Col1,Col2); > > ERROR: multiple primary keys for table "table1" are not allowed > SQL state: 42P16 > > -- > Thanks & Regards, > Brahmeswara Rao J. > Hey, table can have only one primary key. And most probably you already have one. regards, Szymon Lipiński