Create table

IF OBJECT_ID('dbo.TableName', 'U') IS NOT NULL
DROP TABLE dbo.TableName
GO

CREATE TABLE dbo.TableName
(
   CustomerId        INT    NOT NULL   PRIMARY KEY,
   Name      [NVARCHAR](50)  NOT NULL,
   Location  [NVARCHAR](50)  NOT NULL,
   Email     [NVARCHAR](50)  NOT NULL
);
GO