Object naming standards on database server

  • Hi, I like to get some ideas for the  Object naming standards on database server.  There might be different opinions.  However, I like to see what is your idea. 

    These object names can be Database server name, database name, table name, view name, stored procedure name, db role name, etc.

    Thanks.

     

  • A convention I have recently used was:

    tbl_ for main data tables

    tbl_Stage for staging tables

    vew_ for views

    prc_NNN for procedures relating to reports where NNN was also used as part of the report name.

    prc_Cmb for procedures relating to combo boxes in an application.

    prc_Migrate_ for procedures which migrated data from stage tables.

    idx_TableName for indexes.

    I am new to this myself so am interested to see what conventions others follow.

  • table names   _tbl

    views  _vews

    stored Procedures _sprocs

    Just a few ideas.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply