Verification rule "Missing Key or Unique Index" of SQL Serever should ignore history tables (4244676)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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."
Resolution

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.
Defect ID

TDM-5499

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title