Default Value Constraint Name
I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint. For Example: [DF__MyTable__lastM__5A30FF58] I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always ...more »
I have been unable to locate a way to rename a constraint for a default value and that the values that are being created are generally different from server to server since it is creating random characters at the end of the constraint.
For Example: [DF__MyTable__lastM__5A30FF58]
I would really like a way to name the constraint during creation or at least a way to rename the constraint that was created. I am always have to watch scripts that get created with the schema change to make sure that values with those random characters are not in it, otherwise the script will fail on remote servers since they are generally different.
« less full details »
To Toad for SQL Server community

Social Web