1USE [TutorialDB]
2-- Create a new table called 'Customers' in schema 'dbo'
3-- Drop the table if it already exists
4IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
5DROP TABLE dbo.Customers
6GO
7-- Create the table in the specified schema
8CREATE TABLE dbo.Customers
9(
10 CustomerId INT NOT NULL PRIMARY KEY, -- primary key column
11 Name [NVARCHAR](50) NOT NULL,
12 Location [NVARCHAR](50) NOT NULL,
13 Email [NVARCHAR](50) NOT NULL
14);
15GO
16