Tech Off Post

Single Post Permalink

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

    Since most DBA tools worth their salt seperate Sprocs, Views, Functions, and Tables there's no need to prefix them.

    I name tables plurally "Users"/"Customers" and name Sprocs using German syntax: Noun-Verb ("UserGet", "CustomersList", "AccountDelete")

    I don't know why Verb-Noun is so popular when it's better to use Noun-Verb.

    EDIT: And as Sven pointed out, often you're limited to one database so I prefix my tables and sprocs with some sort of application-specific identifier.