Query: Create SQL Database

DROP LOGIN DeMaSy;
CREATE LOGIN [DeMaSy] WITH PASSWORD = 'demasy', DEFAULT_LANGUAGE = [French],CHECK_POLICY = OFF;
Create Database Licence COLLATE SQL_Latin1_General_CP1_CI_AS;
Alter Database Licence Set AUTO_SHRINK ON;
Use Licence;
CREATE SCHEMA DeMaSy;
CREATE USER DeMaSy FOR LOGIN DeMaSy WITH DEFAULT_SCHEMA = DeMaSy;
exec sp_addrolemember 'db_owner', 'DeMaSy';
exec sp_addrolemember 'db_accessadmin', 'DeMaSy';
exec sp_addrolemember 'db_securityadmin', 'DeMaSy';
exec sp_addrolemember 'db_ddladmin', 'DeMaSy';
exec sp_addrolemember 'db_backupoperator', 'DeMaSy';
exec sp_addrolemember 'db_datareader', 'DeMaSy';
exec sp_addrolemember 'db_datawriter', 'DeMaSy';