April 15, 2004 at 8:47 am
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.
April 16, 2004 at 2:28 am
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.
April 16, 2004 at 6:42 am
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