If you do not explicitly specify a collation when creating a database, a default collation is used. The default collation depends on the operating system you are working on.
Start Interactive SQL. Connect to the sample database.
Enter the following query:
SELECT PROPERTY( 'DefaultCollation' );
The default collation is returned.
For more information about this collation, see Choosing collations.