if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Authors] GO CREATE TABLE [dbo].[Authors] ( [au_id] [varchar] (11) NOT NULL , [au_lname] [varchar] (40) NOT NULL , [au_fname] [varchar] (20) NOT NULL , [phone] [char] (12) NOT NULL , [address] [varchar] (40) NULL , [address1] [char] (20) NULL , [city] [varchar] (20) NULL , [state] [char] (2) NULL , [zip] [char] (5) NULL , [contract] [bit] NOT NULL ) ON [PRIMARY] GO