Ignore extra brackets in DEFAULT clause
ArnoldLieberman
Posts: 3 New member
At the moment all the tables in one database are being flagged as changed, because there is an extra set of braces around the default clause (no idea why). Is there an option to suppress this? I'm on 7.0.48.9916.
e.g.
[HashValue] [binary] (16) NOT NULL CONSTRAINT [DF__tbllkaudi__HashV__0DC01A38] DEFAULT (0x00),
e.g.
[HashValue] [binary] (16) NOT NULL CONSTRAINT [DF__tbllkaudi__HashV__0DC01A38] DEFAULT (0x00),
[HashValue] [binary] (16) NOT NULL CONSTRAINT [DF__tbllkaudi__HashV__0DC01A38] DEFAULT ((0x00)),
Thanks
Thanks
Tagged:
Answers
Just to confirm, the double brackets are on the database side and not on the repository?
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools
Looking at the version history for the files in the repository might shed some light regarding this.
Reverting the file in the repository should allow you to workaround the issue.
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools