On-demand training: More Gems from the SQL Prompt Treasure Chest. Watch now.

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

ErinYErinY Posts: 3 New member
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.

Best Answer

  • Eddie DEddie D Posts: 1,700 Rose Gold 5
    Accepted Answer
    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:

    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 Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]


Sign In or Register to comment.