can the CREATE TABLE script in SQL Prompt's popup be configured to omit the COLLATE clauses?
ErinY
Posts: 3 New member
in SQL Prompt
Is there a way to configure SQLPrompt so that (for example)
We configured SQL Server's native scripting functionality to omit it, but we're still seeing it here.
Thanks!
COLLATE SQL_Latin1_general_CP1_CI_ASis 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!
Tagged:
Best Answer
-
Eddie D Posts: 1,802 Rose Gold 5Hi, 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
Answers