How can we help you today? How can we help you today?

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

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?

m1cggmgs9m94.png

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

Comments

2 comments

Sort by
  • 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
    Eddie D
    0
  • ErinY
    Thanks! Will do.
    ErinY
    0

Add comment

Please sign in to leave a comment.