General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>As a general rule you should NEVER have primary keys on dependant data in a table, For Primary keys I always generate a URN type Field ( unique reference number) and other indexes are just Regular type not primary , candidiate or unique
>duplicate table data in a primary key will cause table updates to fail with the error uniqueness of index is violated...
Hi Colin,
We've had no trouble with tables that have a primary key based on 1 field. It's just when compuonding the fields.
URN's are something I'll have to discuss with the DBA. It's an idea.
Thanks
Mike
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