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

CREATE TABLE [dbo].[Artists] (
	[ArtistID] [smallint] IDENTITY (1, 1) NOT NULL ,
	[Artist] [varchar] (255) NOT NULL ,
	[Category] [smallint] NOT NULL ,
	[Comments] [varchar] (8000) NULL ,
	[SortOrder] [smallint] NOT NULL
		CONSTRAINT [DF_Artists_SortOrder] DEFAULT (0) ,
	[Grouping] [smallint] NOT NULL ,
	CONSTRAINT [PK_Artists] PRIMARY KEY  NONCLUSTERED 
	(
		[ArtistID]
	)  ON [PRIMARY] ,
	CONSTRAINT [FK_Artists_Music_Categories] FOREIGN KEY 
	(
		[Category]
	) REFERENCES [dbo].[Music_Categories] (
		[Category]
	)
) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_Artists]
	ON [dbo].[Artists]([Grouping], [SortOrder]) ON [PRIMARY]
GO