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