Assertion: table's key | /r/HasProperty | primary
Facets:
value: normally
type: DEGREE
Source sentences:
text: Every relational table has one primary key.
text: It contains number of tables and each table has its own primary key.
text: The fact table contains business facts (or measures), and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables.
text: Dimension tables often use primary keys that are also surrogate keys.
text: You then add foreign keys to related tables that reference those primary keys.
text: One table can only contain one primary key.
text: A system-versioned temporal table must have a primary key defined and have exactly one PERIOD FOR SYSTEM_TIME defined with two datetime2 columns, declared as GENERATED ALWAYS AS ROW START / END
text: Note that the temporal table must have a primary key defined to be enabled for the table to be enabled for system versioning.