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

ALTER TABLE, add column with COLLATE does not work.

I am adding a column to an existing table, with a collation clause. SQL Prompt formats the collation with square brackets which then causes a syntax error:
ALTER TABLE [dbo].[MyTable] ADD [MyColumn] [nvarchar] (80) COLLATE [Latin1_General_CS_AS] NULL;
Note the brackets around Latin1_General_CS_AS, this is incorrect.

Dave Pendleton
0

Comments

3 comments

Sort by
  • Pete_Ruiz
    Hello @Dave Pendleton

    Thanks for reaching out and sorry that you're having trouble with SQL Prompt. I've managed to reproduce the error using your example so thank you for bringing this to our attention. I'm escalating this to our developers for further review. I'll get back to you with further instruction.

    Kind regards,

    Pete Ruiz
    Redgate Support

    Pete_Ruiz
    0
  • Pete_Ruiz
    Hello @Dave Pendleton ,

    Thanks for your patience on this issue. We've logged a bug report in our internal bug tracking system which can now be referenced by SP-7861. So sorry for any inconvenience. We will update you once we reach resolution.

    Kind regards,

    Pete Ruiz



    Pete_Ruiz
    0
  • TomW
    Hi @Dave Pendleton

    This bug has been fixed in SQL Prompt 10.0.1. We're sorry for the inconvenience caused.

    Please let us know if you find any other issues.

    Best,

    Tom
    Team Prompt
    TomW
    0

Add comment

Please sign in to leave a comment.