Tech Off Post

Single Post Permalink

View Thread: Table/Stored Procedure naming conventions
  • User profile image

    I prefer the Verb-Noun syntax as well. I also prefer plural table names because it seems more consistent with the way you would name a collection or list in your code (and a table is like a collection of rows). It seems to lend itself well to keeping harmony throughout the application.

    As far as prefixes, I definitely agree with the reasoning on why they aren't neccesary. But many would argue that it's not so much the seperation of the objects that causes the need for a prefix, but the distinction in your SQL. So if you have a stored procedure that is querying a table or a view, it would be apparent. I personally don't agree with it, but its a pretty prevalent method.