CREATE TABLE [dbo].[SHStates]
(
[StateID] [int] NOT NULL IDENTITY(1, 1),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StateName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [int] NULL,
[SalesTaxLiabilityGLID] [int] NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_SHStates_Active] DEFAULT ((1)),
[VendorID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHStates] ADD CONSTRAINT [FK_SHStates_VendorID_APVendors] FOREIGN KEY ([VendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO