Script For Table If Exists Persist Data

                   Script For Table If Exists Persist Data

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME='BOOKING')
BEGIN
CREATE TABLE [dbo].[BOOKING](
[BookingId] [int] IDENTITY(1,1) NOT NULL,
[UserId] [int] NOT NULL,
[BranchId] [int] NULL,
[CompanyId] [int] NOT NULL,
[VehicleId] [int] NULL,
[InsuranceCompanyId] [int] NULL,
[CustomerId] [int] NOT NULL,
[ReffererId] [int] NULL,
[WorkProviderId] [int] NULL,
[CorporateCompanyId] [int] NULL,
[CollectionDetailId] [int] NULL,
[DeliveryDetailId] [int] NULL,
[BookIn] [datetime] NULL,
[OriginalDueOut] [datetime] NULL,
[CustomerContact] [datetime] NULL,
[FaxReceiveDate] [datetime] NULL,
[OnSiteDate] [datetime] NULL,
[MiloMeter] [int] NULL,
[RequireDelivery] [bit] NULL,
[OffSiteDate] [datetime] NULL,
[WIPNo] [varchar](20) NULL,
[DateDueIn] [datetime] NULL,
[DateDueOut] [datetime] NULL,
[DeliveryDate] [datetime] NULL,
[RequireCar] [bit] NULL,
[PolicyReference] [varchar](50) NULL,
[IdNumber] [varchar](20) NULL,
[CustFuelLevel] [varchar](20) NULL,
[ClaimNo] [varchar](50) NULL,
[ExcessAmount] [int] NULL,
[SecondaryInvoiceTo] [int] NULL,
[PrimaryInvoiceTo] [int] NULL,
[VatChargeTo] [int] NULL,
[JobType] [int] NULL,
[OwnerContribution] [numeric](6, 2) NULL,
[Status] [bit] NULL,
[ImportBookingId] [int] NULL,
[TCardStatus] [int] NULL,
[Source] [varchar](50) NULL,
[AuthorisedDate] [datetime] NULL,
[CommisionCredit] [int] NULL,
[CommisionStructure] [int] NULL,
 CONSTRAINT [PK_BOOKING_1] PRIMARY KEY CLUSTERED
(
[BookingId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
End