can the CREATE TABLE script in SQL Prompt's popup be configured to omit the COLLATE clauses?

ErinY

Is there a way to configure SQLPrompt so that (for example)

COLLATE SQL_Latin1_general_CP1_CI_AS

is not included in this CREATE TABLE popup?



We configured SQL Server's native scripting functionality to omit it, but we're still seeing it here.
Thanks!

Eddie D

Hi, thank you for your forum post.

Sadly, I do not see any options to disable the COLLATE keyword and details of the collation configured with SQL Prompt.

If you would like to see a feature added to include or ignore collation details, I recommend that you create a feature request in the SQL Prompt User Voice forum, available via this link:
https://redgate.uservoice.com/forums/94413-sql-prompt

The User Voice forum is the best place to submit new feature suggestions. The theory being the more votes and comments a topic receives will increase it chances of being included in a future version of SQL Prompt.

Many Thanks
Eddie

ErinY

Thanks! Will do.