GO

/** Object: Table [dbo].[Catalogue] Script Date: 08/26/2007 00:59:51 **/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Catalogue](

[ID] [int] IDENTITY(1,1) NOT NULL,

[Description] varchar COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Type] [int] NULL,

[Manufacturer] varchar COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[Quantity On Hand] [int] NULL,

[Reorder Point] [int] NULL,

[Reorder Quantity] [int] NULL,

CONSTRAINT [PK_Catalogue] PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX OFF, IGNORE_DUP_KEY OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[Catalogue] WITH CHECK ADD CONSTRAINT [FK_Catalogue_VEHICLE TYPES] FOREIGN KEY([Type])

REFERENCES...