/****** Object: Table [dbo].[InventVendor] Script Date: 08/08/2018 12:42:56 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[InventVendor]( [InventVendorKey] [int] IDENTITY(1,1) NOT NULL, [Name] [nvarchar](25) NULL, [Addr1] [nvarchar](25) NULL, [Addr2] [nvarchar](25) NULL, [City] [nvarchar](25) NULL, [State] [nvarchar](15) NULL, [Zip] [nvarchar](15) NULL, [Phone] [nvarchar](25) NULL, [Fax] [nvarchar](25) NULL, [VendorID] [nvarchar](25) NULL, [SalesRep] [nvarchar](50) NULL, [Terms] [nvarchar](50) NULL, [Note] [nvarchar](255) NULL, [EntSync] [datetime] NULL, [SyncStatus] [int] NOT NULL, [EntID] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [InventVendorKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[InventVendor] ADD DEFAULT ((0)) FOR [SyncStatus] GO ALTER TABLE [dbo].[InventVendor] ADD DEFAULT ((0)) FOR [EntID] GO