CODEWITHSUNDEEP
oracle-sqldeveloper
Shahid Ghafoor
Shahid Ghafoor

Reputation: 3103

Oracle SQL Developer diamon icon in model

enter image description here

I have created model in Oracle SQL Developer, in bottom there are 2 icons

1 is key (which is primary key) , 2nd is diamond ? what diamond showing ?

Upvotes: 6

Views: 2759

Answers (2)

thatjeffsmith
thatjeffsmith

Reputation: 22427

The diamond items show you the INDEXES on that table.

enter image description here

The red asterisk character to the left of the column name indicates the column has a NOT NULL constraint.

If we pull up the table in the database, we can see the indexes list and the model diagram side by side to verify.

enter image description here

In Oracle, a PRIMARY_KEY constraint automatically creates an INDEX of the same name, UNLESS you already have an INDEX and you tell the PRIMARY_KEY constraint to just re-use your existing INDEX.

Upvotes: 9

Amir Tofighi
Amir Tofighi

Reputation: 307

The diamond is showing that it is a NOT NULL field.

Upvotes: -2

Related Questions