\Yezervasyon\SQL_CREATE.sql

Return Back
If(db_id(N'CUSTOM_DB') IS NULL)
BEGIN
CREATE DATABASE CUSTOM_DB
END

use CUSTOM_DB

IF NOT EXISTS
(SELECT name
FROM master.sys.server_principals
WHERE name = 'CUSTOM_USER')
BEGIN
CREATE LOGIN CUSTOM_USER WITH PASSWORD = 'CUSTOM_PASSWORD', DEFAULT_DATABASE = CUSTOM_DB
CREATE USER CUSTOM_USER FOR LOGIN CUSTOM_USER
ALTER ROLE db_ddladmin ADD MEMBER CUSTOM_USER
ALTER ROLE db_datareader ADD MEMBER CUSTOM_USER
ALTER ROLE db_datawriter ADD MEMBER CUSTOM_USER
END
GO

DROP TABLE IF EXISTS CUSTOM_TABLE
GO

IF NOT EXISTS (SELECT [name] FROM sys.tables WHERE [name] = 'CUSTOM_TABLE')
BEGIN
CREATE TABLE CUSTOM_TABLE(
Id INT PRIMARY KEY IDENTITY(1, 1),
CUSTOM_PROPERTY NVARCHAR(11),
CUSTOM_PROPERTY NVARCHAR(25),
CUSTOM_PROPERTY NVARCHAR(50),
CUSTOM_PROPERTY NVARCHAR(50),
CUSTOM_PROPERTY DATE,
CUSTOM_PROPERTY NVARCHAR(10),
CUSTOM_PROPERTY BIT
)
END