I need to change the primary key to a different column.
The table is small with about 10 rows of data.
The current primary key is used as a forgien key in 3 other tables.
The new primary key will become the new forgien key.
Are there any things which I need to be aware of. Is it as easy as:
1. Drop forgien key constaints.
2. Drop primary key constraint.
3. Create new primary key.
4. Create new forgien keys.