How can we help you today? How can we help you today?

Object names containing [ or ] symbols

I have encountered a small bug: when object name contains symbols [ or ] it is scripted incorrectly.
In my case there was a constraint names like "n1].[n2" (I know that's not a great ide to use name like that, but it just happened this way).
Then database compare script was created like this:
...CONSTRAINT [n1].[n2] DEFAULT...
which cannot be accepted by SQL server, it should have been
...CONSTRAINT [n1]].[n2] DEFAULT...
or
...CONSTRAINT "n1].[n2" DEFAULT...

Yuri
Yuri
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi Yuri,

    Thanks for pointing this out. I have logged an issue for our developers to look at with a reference number of SC-3866. If we can support identifiers in a future version, we will look into that.

    Thanks!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.