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

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


BEGIN TRANSACTION
ALTER TABLE dbo.NewAnswer ADD CONSTRAINT
	NewAnswer_PK PRIMARY KEY NONCLUSTERED
	(
	NewAnswerID
	) ON [PRIMARY]

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