HWA1_P4_1.sql

/* -------------------------------------------------------------------------
   Yu Cheng
   ICS 321 Assignment 1
   September 18, 2008

   PART 4.1
   Create a script that will create the BILLET table as defined in the
   Metadata Dictionary documentation.
   ------------------------------------------------------------------------- */

USE DB9975
GO

CREATE TABLE BILLET
(
	Id          INT           NOT NULL,
	Title       NVARCHAR(50)  NOT NULL,
	Description NVARCHAR(150) NOT NULL

	CONSTRAINT PK_BILLET PRIMARY KEY (Id)
)
GO