MS-SQL Database 만들기

USE master;
GO

IF DB_ID (N'lesstif') IS NOT NULL
DROP DATABASE lesstif;
GO

CREATE DATABASE lesstif;
GO

-- Verify the database files and sizes
SELECT name, size, size*1.0/128 AS [Size in MBs]
FROM sys.master_files
WHERE name = N'lesstif';
GO

USE lesstif;
GRANT CONTROL ON DATABASE::lesstif TO lesstif;
GO

USE lesstif;
GRANT CREATE DATABASE TO [lesstif];
GO