use keck go /* table was keck.dbo.Formats */ drop table Formats go create table Formats ( formid char(3) NOT NULL, format char(20) NOT NULL, uid smallint NULL, stamp smalldatetime NULL ) go grant select on Formats to public go grant insert on Formats to deimos go grant delete on Formats to deimos go grant update on Formats to deimos go sp_primarykey Formats, formid go