IF NOT (EXISTS
(
    SELECT name
    FROM sysobjects
    WHERE name = 'TrackingHeader'
)
       )

Begin
CREATE TABLE [dbo].[TrackingHeader](
	[Id] [UNIQUEIDENTIFIER] NOT NULL,
	[NuOrder] [INT] NOT NULL,
	[Family] [NVARCHAR](100) NOT NULL,
	[OrderDate] [DATETIME] NOT NULL,
	[Mobile] [VARCHAR](11) NOT NULL,
	[Address] [NVARCHAR](150) NULL,
	[Description] [NVARCHAR](150) NULL,
	[DeliveryDate] [VARCHAR](50) NULL,
 CONSTRAINT [PK_TrackingHeader] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)
) ON [PRIMARY]
ALTER TABLE [dbo].[TrackingHeader] ADD  CONSTRAINT [DF_TrackingHeader_Id]  DEFAULT (NEWID()) FOR [Id]
ALTER TABLE [dbo].[TrackingHeader] ADD  CONSTRAINT [DF_TrackingHeader_OrderDate]  DEFAULT (GETDATE()) FOR [OrderDate]
End

