Every NVARCHAR/VARCHAR/NCHAR/CHAR column defined in a CREATE TABLE or ALTER TABLE … ADD
in code (comment-stripped lines) without a COLLATE clause, or, when collation is given, with
a COLLATE naming a different collation. Temporary tables are skipped, and a table variable
(DECLARE @t TABLE (…)) never matches, since it is not a CREATE TABLE.
Every
NVARCHAR/VARCHAR/NCHAR/CHARcolumn defined in aCREATE TABLEorALTER TABLE … ADDincode(comment-stripped lines) without aCOLLATEclause, or, whencollationis given, with aCOLLATEnaming a different collation. Temporary tables are skipped, and a table variable (DECLARE @t TABLE (…)) never matches, since it is not aCREATE TABLE.