• A relation must have a primary key. If your table does not have a primary key, then it's the physical implementation of something that doesn't exist in the relational model.

    Maybe an Excel spreadsheet, a CSV file, but defintely not a relation.

    No primary key can be good for temporary tables or staging tables.

    -- Gianluca Sartori