Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Primary Key in SQL developer and SQL Script for a Table

872483Dec 8 2014 — edited Dec 8 2014

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.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 5 2015
Added on Dec 8 2014
#sql-developer, #sqldeveloper
5 comments
1,703 views