use keck go /* table was keck.dbo.AgentTypes */ drop table AgentTypes go create table AgentTypes ( atype char(1) NOT NULL, atdesc varchar(40) NOT NULL, uid smallint NULL, stamp smalldatetime NULL ) go grant select on AgentTypes to public go grant insert on AgentTypes to deimos go grant delete on AgentTypes to deimos go grant update on AgentTypes to deimos go sp_primarykey AgentTypes, atype go