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

    Primary Key in SQL developer and SQL Script for a Table

    872483

      Hi,

       

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

       

      Like, I checked this thread,

      https://community.oracle.com/thread/1098041?q=Primary%20Key%20in%20SQL%20developer

       

      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)

       

      Thanks.