Return
-
Title
Verification rule "Missing Key or Unique Index" of SQL Serever should ignore history tables -
Description
Receiving verification warning "Missing Key or Unique Index" for history table. However, Microsoft documentation states, "A temporal table must have a primary key defined in order to correlate records between the current table and the history table, AND THE HISTORY TABLE CANNOT HAVE A PRIMARY KEY DEFINED."
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.