BDG Scenario 1

Author.sql

If Exists (Select * From sysobjects Where name = N'author' And user_name(uid) = N'dbo')
    Drop Table dbo.author
Go

Create Table dbo.author
    (
    auth# int Not Null Identity (1, 1),
    fname varchar(128) Not Null,
    lname varchar(128) Not Null,
    timestamp timestamp Not Null
    )
Go
Alter Table dbo.author Add Constraint
    PK_author Primary Key Nonclustered
    (
    auth#
    )
Go