4 Replies Latest reply: Jun 1, 2009 11:05 AM by 704468 RSS

    Adding another column to a primary key

    704468
      I am an SQL Server and DB2 DBA and have no clue about the Oracle. However, we end up having a client who use Oracle database and a question came as how an additional column can be added to a selected primary key columns. The current primary key consist of 2 columns and another column needed to be included in the primary key. What is the best way to do this. Can it be done by PL/SQL code ?. Anything special need to be done ?. Sorry, I don't have the Oracle version nor the OS info.

      Thanks.