sql server - Is there an option to tell SSMS not to use the OPTIMIZE_FOR_SEQUENTIAL_KEY flag when generating scripts?

Question

SSMS has started including the flag OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF when generating table creation scripts. These scripts then fail when attempting to deploy the DB project from Visual Studio.

While I can manually remove the flag from each of the scripts I was wondering if there's a setting in SSMS so that it doesn't reference that flag at all (whether off or on)?

question from:https://stackoverflow.com/questions/65834551/is-there-an-option-to-tell-ssms-not-to-use-the-optimize-for-sequential-key-flag

Answer 1

Waitting for answers