UCS_BASIC can be specified as a collation for columns containing Unicode data (nchar and nvarchar data types) or all character data types when using UTF8. This collation is useful when performance and efficiency is more important than the order that the data is collated in.

This is documented on the the CREATE TABLE and ALTER TABLE statement descriptions in the SQL Reference Guide.