April 8th, 2009
Naming Standards (Part 3 of 4)
Posted by
admin in
O. Database Objects
Here is a sample naming standard:This naming standard uses the long object names of the SQL standard.
Prefixes:
D_ = Database
C_ = Catalog
S_ = Schema
No prefixes on lower higherarchy objects.
Suffixes:
_TBL = Table
_VIEW = View
_IDX1 = Indexes
_ID = Column definition of a key
_PK = Primary key
_FK1 = Foreign keys
_CK1 = Constraints
_UNQ = UNIQUE
_CHK = CHECK
…
Comments Off
