if exists (select * from dbo.sysobjects where id = object_id('authortitles') and OBJECTPROPERTY(id, 'IsUserTable') = 1) drop table authorstitles GO CREATE TABLE authorstitles ( au_id id NOT NULL , au_lname varchar(40) NOT NULL , au_fname varchar(20) NOT NULL , phone char(12) NOT NULL , address varchar(40) NULL , city varchar(20) NULL , state char(2) NULL , zip char(5) NULL , contract bit NOT NULL , author_titles int NULL ) GO