primary key problem

[luds]

I would like to change the PRimary Key for a table in a db.

I've got to ALTER TABLE tablename <enter> but what comes next? All my efforts just result in syntax errors!

Thanks

luds

 

[bostonfrog]

You will probably not be able to ALTER the table until you remove the relationships first and then set them again. Otherwise, you'd best look up the rules for using the ALTER TABLE syntax to find out how you can do this without interfering with the referential integrity rules you've set on the tables.