Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Graig,
>As Larry said, you should not reuse primary keys. There is a KB article on my web site that discusses this and provides code to generate new PKs.
As Walter says, you should watch out with these kind of statements. This person might have a circumstance where generated PKs are only complicating things. There is NO uniform statement in the DB world that you should use generated PKs in all cases. Please read "Joe Celko's' articles.
Walter,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only