Define column collation in markup [SQL Server]

As a user, I would like the ability to define the collation against a column in the markup for cases where the require collation is different to the database default collation.

e.g. Latin1_General_Bin or Latin1_General_CS_AS

```
CREATE TABLE dbo.MyTable (CharCol NVARCHAR(50) COLLATE Latin1_General_CS_AS);

CREATE TABLE dbo.MyTable (CharCol VARCHAR(50) COLLATE Latin1_General_BIN);
```