5 Replies Latest reply on Dec 8, 2014 9:38 PM by rp0428

    Primary Key in SQL developer and SQL Script for a Table




      Primary key is not shown anywhere in Column Tab in SQL Developer (Version


      Like, I checked this thread,



      So it says, its not shown. But since the thread was like 4 years old and for different version, just wanted to cross check if this feature is added in recent times.


      One more thing, I tried to take the DDL script for the table, it no where shows as Primary Key, it just shows as UNIQUE INDEX.

      Is unique index same as primary key??

      If same, Why to create unique index instead of primary key??

      Why oracle EBS standard tables use unique index instead of primary key?? (Sorry if it is irrelevant to this link)