What are the challenges you face when working across database platforms? Take the survey

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;<br>
Note the brackets around Latin1_General_CS_AS, this is incorrect.


Best Answer

  • Options
    TomWTomW Posts: 108 Gold 1
    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.


    Team Prompt
    Software Engineer for SQL Prompt
    Redgate Software


  • Options

    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

  • Options

    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

Sign In or Register to comment.