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

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

  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com


Sign In or Register to comment.