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 on creating an IDENTITY column.
