I am generating SQL server DDL. The DDL includes collation such as,
CREATE TABLE [MyTable]
[PrimaryKey] int NOT NULL ,
[CharCol] varchar(10) COLLATE Latin1_General_CI_AS NOT NULL
There is not a switch in the forward engineer options to disable generating the keyword COLLATE.
How do I quickly remove the COLLATE statements when I Forward Engineer SQL Server SQL DDL?
The way to remove the collate statements is,
- Using the Bulk Editor, one can easily do a mass deletion of all collations values for the attributes.
- However, you also need to remove it from the database. Right-click on Databases in the Model Explorer and remove any text from the Collation Column for each database.