Return
-
Title
Constraint name is not maintained during table alter when table change requires drop and recreation -
Description
Table constraint name is not maintained when an alter table is done and requires the table to be dropped and recreated. The DDL generated recognizes the constraints and renames them near the beginning of the script, but fails to recreate them using the name assigned to them prior to the drop.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.