As said there is no definitive but here's my two pennies worth. >> After all, we are talking about sets here, and it's natural to pluralise them.
My old database teacher would have a fit with that... but each to their own :) We use two words to describe (and name) each table An example here would be TABLE: PROJECT_DETAIL COLUMN: PD_ID, PD_NAME... etc The column name is collapsed two a two letter prefix, not actually came across a time when their was a duplicate prefix within a schema but I'm sure if it happened you could use a different Anyways... -- dc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181826 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54