Listing 1: T-SQL Script That Creates Database Tables

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'Titles') AND 
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE Titles
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'Authors') AND 
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE Authors
GO
CREATE TABLE Authors (
	AuthId [int] IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	FirstName [varchar] (50) NOT NULL ,
	LastName [varchar] (50) NOT NULL)
GO
CREATE TABLE Titles (
	PubId [int] IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	Title [varchar] (128) NOT NULL ,
	Pub_Date [datetime] NULL ,
	Price [money] NULL ,
	AuthRef [int] FOREIGN KEY REFERENCES Authors(AuthID) NOT NULL)
GO