getting ddl of primary key constraint
694352May 19 2009 — edited May 20 2009Hi
I want to drop a primary key index,
I think, In order to do that I want to drop primary key constraint.
When I get the ddl of the primary key index, it is like
CREATE UNIQUE INDEX "NI"."PREM_PK" ON "NI"."PREM" ("BRANCH_ID", "PRODUCT", "COMPANY_ID","SUM_SEQNO")
..
..
..
I dont undertand why there are more than 1 columns.
As far as I know primary key should be in one column.
How can I get the ddl of primary key constraint? I am little bit confused