create-database.sql

-- write your queries here
-- Create a new database called 'SimpleDB'
-- Connect to the 'master' database to run this snippet
USE master
GO

-- Create the new database if it does not exist already
IF NOT EXISTS (
 SELECT name
 FROM sys.databases
 WHERE name = N'SimpleDB'
 )
 CREATE DATABASE SimpleDB
GO

USE SimpleDB
GO

-- Create a new table called 'customers' in schema 'dbo'
-- Drop the table if it already exists
IF OBJECT_ID('dbo.customer', 'U') IS NOT NULL
 DROP TABLE dbo.customers
GO

-- Create the table in the specified schema
CREATE TABLE dbo.customers (
 customerId INT NOT NULL PRIMARY KEY, -- primary key column
 cust_name [NVARCHAR](30) NOT NULL,
 cust_address [NVARCHAR](80) NOT NULL
 -- specify more columns here
 );
GO