Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312

    Unanswered: Naming Conventions

    Most of the programming I do is in Access. I like to use naming conventions for all my tables, queries, etc. I am now moving several databases to SQL Server. Does anyone know of a good resource for naming convetions in SQL Server. Website, book?

  2. #2
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    this is a good one.

    LINK

    its the one that i use because of the indicative naming of objects like FK's

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Use a naming convention that makes your code read as much like an English language sentence as possible.

    I've never had any use for "tblTableName" or "SP_MyProcedure", or "SomeData_View". It focuses attention on the internal workings of SQL Server when you or the person debugging your code should be focused on the logic and the business rules.

    And no unnecessary aliases, please!

    Select MT.MyField, YT.YourField from MyTable MT inner join YourTable YT on MT.PKey = YT.Pkey????

    Blech!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •