if exists(select * from sysobjects where ID = object_id("guestbook")) drop table guestbook go drop table guestbook create table guestbook( lybid int identity(1,1), guestname varchar(40) NOT NULL, guestitle varchar(100) NOT NULL, guestcomm varchar(8000), putdate varchar(20), puttime varchar(10), guestemail varchar(50), emailflag bit, rootid int, fromip varchar(25), orderstr varchar(3) )
