ALTER TABLE, add column with COLLATE does not work.

Dave Pendleton

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.

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

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

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