-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
alter table e drop constraint PrimaryKey;
alter table e alter column id counter;
alter table e add constraint PrimaryKey primary key(id);
