/*
DBA_Assist

DBA_AssistID	- PK. identity field for this table
TSQLCode			- holds code that is to be run
InsDt				- Insert timestamp for the entry.
ComplDt			- timestamp for when this code is run
*/
if object_Id('DBA_Assist') Is Not Null
 drop table DBA_Assist
go

CREATE TABLE DBA_Assist
( DBA_AssistID int identity( 1, 1),
	TSQLCode varchar( 250),
	InsDt    datetime,
	compldt  datetime)
GO
grant select, insert, update, delete on DBA_Assist to WebUser
go

BEGIN TRANSACTION
ALTER TABLE dbo.DBA_Assist ADD CONSTRAINT
	PK_DBA_Assist PRIMARY KEY
	(
	DBA_AssistID
	) ON [PRIMARY]

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