/****** Object: Table [dbo].[Book_Categories] Script Date: 2/2/2000 1:31:09 AM ******/
if exists (select * from sysobjects
                where id = object_id(N'[dbo].[Book_Categories]') and
                        OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Book_Categories]
GO

CREATE TABLE [dbo].[Book_Categories] (
        [Category] [smallint] IDENTITY (1, 1) NOT NULL ,
        [Description] [varchar] (50) NOT NULL ,
        [SortOrder] [smallint] NOT NULL
                CONSTRAINT [DF_Book_Categories_SortOrder] DEFAULT (0),
        [Comments] [varchar] (1000) NULL ,
        CONSTRAINT [PK_Book_Categories] PRIMARY KEY  NONCLUSTERED 
        (
                [Category]
        )  ON [PRIMARY] 
) ON [PRIMARY]
GO

This page was last updated on May 01, 2006 04:28 PM.