if object_Id('Answer') Is Not Null
drop table Answer
go

CREATE TABLE Answer
( 	AnswerID int identity( 1, 1),
	UserID int,
	QuestionID int,
	Answer varchar( 20)
)
GO
grant select, insert, update, delete on Answer to public
go


BEGIN TRANSACTION
ALTER TABLE dbo.Answer ADD CONSTRAINT
	Answer_PK PRIMARY KEY NONCLUSTERED
	(
	AnswerID
	) ON [PRIMARY]

GO
COMMIT
go
if object_id( 'Answer') Is Null
select 'Error: Answer Not Created'
else
select ' Answer Created'
go