> Does anyone here follow the following naming convention in SQL Server?
> Tables: tbl_tablename > Views: vw_viewname > Stored Procedures: sp_procedurename > I'm just tyring to get a quick poll as to who might follow this way of > naming.. > Thanks. You can reply off list to me.. I use some variations... I don't tend to use this naming convention with tables, usually opting for something like bcpa_user where "bcpa" is the abbreviation for the client's name. With views I usually use vViewName and with stored procedures I vary ... when I'm working on a project for a client I usually use sp_procedurename , though in some of my own projects i've used variations like tap_procedurename where "tap" is an abbreviation for the project I'm working on and the prefix is intended primarily to keep my procedures in a contiguous area in the enterprise manager view... I probably use vViewName with views because I usually have fewer of them than I have tables and stored procedures... Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
