Re: [SQL] Changing primary keys

2004-03-10 Thread Jonathan Gardner
On Wednesday 10 March 2004 09:17 am, David wrote: > Is it possible to change the primary key of a relation? I want to add an > attribute, that i already have in the realtion, to the primary key (yes i > realise i designed my model pretty badly) > It sure is. First, ensure that the values are inde

[SQL] Changing primary keys

2004-03-10 Thread David
Is it possible to change the primary key of a relation? I want to add an attribute, that i already have in the realtion, to the primary key (yes i realise i designed my model pretty badly) ---(end of broadcast)--- TIP 7: don't forget to increase you