Table Requirements
In order to be a crr a table must:
- Have one or more primary key columns
- Have no enforced foreign key constraints. Unenforced foreign keys are fine.
- Have no other unique indices besides the primary key(s)
- Columns are either nullable or have a default value.
Tables that are not crrs have no requirements.
Related: