Object naming standards on database server

• George Guo

  SSC Enthusiast

  Points: 135

  More actions

  April 15, 2004 at 8:47 am

  #85174

  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.

   

• Paul Wheeler

  Grasshopper

  Points: 12

  More actions

  April 16, 2004 at 2:28 am

  #503080

  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.

• cutiger93

  SSC-Addicted

  Points: 485

  More actions

  April 16, 2004 at 6:42 am

  #503110

  table names   _tbl

  views  _vews

  stored Procedures _sprocs

  Just a few ideas.