Every source table must contain an IDENTITY column, which uniquely identifies each row and provides a means of joining the index table and the source table.
For example, to add an IDENTITY column to the reviews table, enter:
alter table reviews add id numeric(10,0) identity
See “Adding an IDENTITY column to a source table” for more information.
