WEB LISTING 1: Command File to Create Sample Tables

CREATE TABLE [dbo].[TitlesNew] (
	[title_id] [tid] NOT NULL ,
	[title] [varchar] (80) NOT NULL ,
	[type] [char] (12) NOT NULL ,
	[pub_id] [char] (4) NULL ,
	[price] [money] NULL ,
	[advance] [money] NULL ,
	[royalty] [int] NULL ,
	[ytd_sales] [int] NULL ,
	[notes] [varchar] (200) NULL ,
	[pubdate] [datetime] NULL 
) ON [PRIMARY]
GO