/****** Object: Table [dbo].[CDs] Script Date: 2/2/2000 11:59:06 PM ******/
if exists (select * from sysobjects
                where id = object_id(N'[dbo].[CDs]') and
                        OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CDs]
GO

CREATE TABLE [dbo].[CDs] (
        [TitleID] [int] NOT NULL ,
        [ArtistID] [smallint] NOT NULL ,
        [Comments] [varchar] (8000) NOT NULL ,
        [SortOrder] [smallint] NOT NULL
                CONSTRAINT [DF_CDs_SortOrder_1] DEFAULT (0),
        CONSTRAINT [PK_CDs] PRIMARY KEY  NONCLUSTERED 
        (
                [TitleID]
        )  ON [PRIMARY] ,
        CONSTRAINT [FK_CDs_Artists] FOREIGN KEY 
        (
                [ArtistID]
        ) REFERENCES [dbo].[Artists] (
                [ArtistID]
        )
) ON [PRIMARY]
GO

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