Skip to content

Instantly share code, notes, and snippets.

@indyfromoz

indyfromoz/Alter-Collation.sql

Created October 31, 2013 05:34
Show Gist options
  • Save indyfromoz/7244748 to your computer and use it in GitHub Desktop.
Save indyfromoz/7244748 to your computer and use it in GitHub Desktop.
Download ZIP
Alter the collation of a SQL database
Raw
Alter-Collation.sql
USE master;
GO
ALTER DATABASE MyOptionsTest
COLLATE French_CI_AS ;
GO
--Verify the collation setting.
SELECT name, collation_name
FROM sys.databases
WHERE name = N'MyOptionsTest';
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment