use keck go /* table was keck.dbo.Agents */ drop table Agents go create table Agents ( agentid int NOT NULL, aname varchar(20) NOT NULL, atype char(1) NOT NULL, author varchar(20) NULL, lang char(10) NULL, docURI varchar(100) NULL, rev char(12) NULL, ref char(12) NULL, rank char(12) NULL, uid smallint NULL, stamp smalldatetime NULL, owner int NULL, adesc varchar(255) NULL, srcURI varchar(100) NULL, rel char(20) NULL ) go grant select on Agents to public go grant insert on Agents to deimos go grant delete on Agents to deimos go grant update on Agents to deimos go sp_primarykey Agents, agentid go