Re: Can I change the primary key on a table?

deanbrown3d_at_yahoo.com wrote:

> Perfect! People told me it was harder than that! Perhaps this is a new
> feature in recent releases?

No, it's always been this easy. Dealing with all the consequences is the hard part. i.e. are there any tables that have a foreign key relationship to this table? How are your apps going to handle the change? Making changes to your data design after it's been put into production will usually have repurcussions, even if the changes themselves are fairly easy to do.

P.S. Composite primary keys have their own set of problems. Many people recommend avoiding them altogether.

-- 
//-Walt
//
//