Jochem, Your right, but when you have multiple apps using the same DB or when the user account does not have permissions to do "CREATE SCHEMA", this comes in handy for me. Also, I do the "'My Sample Application' == msa_" thing anyway in my file naming so this helps in keeping things straight in my head.
The more important part of my naming convention is the table name after the app abbr. This way I know what column goes to what table without any guesswork (helps with knowledge transfer too). Also the "app abbr" comes in handy when I have multiple user tables (or other similar tables). Ian On Tue, 19 Oct 2004 16:06:59 +0200, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > Ian Sheridan wrote: > > > > Name of application == "My Sample Application" == msa_ > > > > Table for users == msa_usr_users > > Application prefix? Isn't that what schema's are for? > CREATE SCHEMA msa ... > CREATE TABLE msa.users ... > > Jochem -- ---------------------- Ian Sheridan http://www.savagevines.com ---------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:181857 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
