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

Related posts about naming

Related posts about database-development