Session Collation
The SET SESSION COLLATION collation_name sets the default collation to be used when creating tables. The session default collation name can be NONE, UCS_BASIC, UNICODE or UNICODE_CASE_INSENSITIVE.
For example:
CREATE TABLE tbl(col NVARCHAR(10) COLLATE UCS_BASIC);
can also be achieved by first changing the default SESSION collation:
SET SESSION COLLATION UCS_BASIC;
CREATE TABLE tbl(col NVARCHAR(10));