Options

Ignore extra brackets in DEFAULT clause

ArnoldLiebermanArnoldLieberman Posts: 3 New member
in SQL Source Control
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),
[HashValue] [binary] (16) NOT NULL CONSTRAINT [DF__tbllkaudi__HashV__0DC01A38] DEFAULT ((0x00)),

Thanks

Tagged:
· Share on Twitter

Answers

  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    There isn't an option to ignore those double brackets.
    Just to confirm, the double brackets are on the database side and not on the repository?
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
  • Options
    ArnoldLiebermanArnoldLieberman Posts: 3 New member
    It looks like the double brackets are in the repository.
    · Share on Twitter
  • Options
    Sergio RSergio R Posts: 610 Rose Gold 5
    OK, because it would be strange if SQL Source Control scripted it that way. I suspect that the file in the repository was edited possibly by another application.
    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.
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
Sign In or Register to comment.