Verification rule "Missing Key or Unique Index" of SQL Serever should ignore history tables
説明
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."
対策
WORKAROUND:
The verification rule "Missing Key or Unique Index" is just a general warning. You can turn off this warning in verification settings.
STATUS:
This issue is fixed in Toad Data Modeler 7.1. This version can be downloaded from the downloads section of our website, which you can access by clicking here.
