Stored procedure Naming conventions?
Posted
by
Chris
on Programmers
See other posts from Programmers
or by Chris
Published on 2011-01-26T15:44:12Z
Indexed on
2012/11/07
11:20 UTC
Read the original article
Hit count: 386
One of our senior developers has stated that we should be using a naming convention for stored procedures with an "objectVerb" style of naming such as ("MemberGetById") instead of a "verbObject" type of naming ("GetMemberByID"). The reasoning for this standard is that all related stored procedures would be grouped together by object rather than by the action.
While I see the logic for this way of naming things, this is the first time that I have seen stored procedures named this way. My opinion of the naming convention is that the name can not be read naturally and takes some time to determine what the words are saying and what the procedure might do.
What are your takes on this? Which way is the more common way of naming a stored proc, and does a what types of stored proc naming conventions have you used or go by?
© Programmers or respective owner