ALTER TABLE :table ADD PRIMARY KEY (specimen_id);