There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Visio offers four index types for database tables. The two of interest to me are:
Unique index only
Unique contstraint only
I have created one of each in a test table in my diagram. When I forward engineer, both are scripted as a "CREATE UNIQUE INDEX". I expected the "Unique constraint only" to generate a constraint, not an index.
While both can get the job done for data integrity (with subtle differences), it is problematic if I start with a reverse-engineered db, which uses constraints. I get a lot of "false" differences just by forward engineering the db, without making
any changes to it, because the constraints become indexes.
I realize that I am choosing what Visio calls an "Index type", and I am expecting a resulting contstraint; but, what is the point of offering me two choices that give the same result? Is my issue with Visio or the Forward Engineer add-in? Any help
would be appreciated.