ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Primary Key - on table itself, or as an Index? (take three)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Primary Key - on table itself, or as an Index? (take three)

    *Re-posting because I think my previous post glitched in the forum and became unreadable*

    Should I define my SQL table with a primary key within the Create Table statement, or should I create the table with no primary key, and use create index to add a unique key?

    I've seen a number of people say that physical files should never have unique keys, and instead logicals should provide the unique key. I never understood why, and I don't know if it is/was true.

    So my question is:
    Is/was this true for DDS files?
    Is/was this true for SQL tables?
    And why?
Working...
X