what _Zorro_ says is right
you will have to use this
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[xHawk]') AND type = N'U')
DROP TABLE [dbo].[xHawk]
go
GRANT CREATE TABLE TO test CREATE TABLE xHawk(StudentId INTEGER CONSTRAINT PkeyMyId PRIMARY KEY,Name CHAR(50),Address CHAR(255),Contact INTEGER)
If the execption is related permission it gives the following error.
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
The specified schema name "dbo" either does not exist or you do not have permission to use it.