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