sql caps constraint code example

Example: tsql table column constraint must be uppercase

alter table dbo.TableName 
  add constraint CK_TableName
  check (upper(ColumnNameToCheck) = ColumnNameToCheck collate Latin1_General_BIN2)