/*
UserDetail

UserDetailID 	- PK indentity field for the table
areacode			- areacode of the phone number
phone				- full area code entered by the user.
*/
if object_Id('UserDetail') Is Not Null
 drop table UserDetail
go

CREATE TABLE UserDetail
(	UserDetailID int identity( 1, 1),
	areacode char( 3),
	phone varchar( 20)
)
GO
grant select, insert, update, delete on UserDetail to WebUser
go

/*
exec sp_Bindefault dfBlank, 'UserDetail.'
*/

BEGIN TRANSACTION
ALTER TABLE dbo.UserDetail ADD CONSTRAINT
	PK_UserDetail PRIMARY KEY
	(
	UserDetailID
	) ON [PRIMARY]

GO
COMMIT
go
if object_id( 'UserDetail') Is Null
 select ' UserDetail Not Created'
else
 select ' UserDetail Created'
go