Posted by BillCo on 05/04/07 09:47

Thanks to everyone for their replies - very informative!

- I've dropped the whole _PK, _FK thing
- I've also dropped the table abreviation prefix, except to dis-
ambiguate common column names

Interestingly, I've found that going while through my test database
structure re-naming elements, that I've exposed flaws in my entity
relationship design - using redundant artificial Identifiers and
confusing data with meta-data being the biggest disasters!! - and come
away with a deeper understanding of the relational database model.

So thanks to all!

>Get a copy of SQL PROGRAMMING STYLE
might just do that!

[Back to original message]