> So what you are saying is that if I recreate the table I can insert all > the old values back into the newly created table (including the primary > key values) and the primary key column wont complain? That's a bit > scary!
It's not scary, it's essential. In a real database, an integer primary key will almost always be referenced by one or more foreign keys. Changing the primary key would destroy referential integrity. Regards --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
