1. Example. CREATE TABLE.sql

IF NOT EXISTS(SELECT 1 FROM sys.tables WHERE name = 'Customer')
CREATE TABLE Customer(
   Id                   INT                  IDENTITY,
   FirstName            NVARCHAR(40)         NOT NULL,
   LastName             NVARCHAR(40)         NOT NULL,
   City                 NVARCHAR(40)         NULL,
   Country              NVARCHAR(40)         NULL,
   Phone                NVARCHAR(20)         NULL,
   CONSTRAINT           PK_CUSTOMER PRIMARY KEY(Id)
);
GO