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

CREATE TABLE [dbo].[Authors] (
        [AuthorID] [int] IDENTITY (1, 1) NOT NULL ,
        [Author] [varchar] (50) NOT NULL ,
        CONSTRAINT [PK_Authors] PRIMARY KEY  NONCLUSTERED 
        (
                [AuthorID]
        )  ON [PRIMARY] 
) ON [PRIMARY]
GO

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