Here is another sample naming standard:This naming standard uses shorter object names appropriate for a small database on a PC computer. We are using the template SSSEEEOM where:

SSS identifies the application system. Here CUS is for CUSTOMER.

EEE shows the entity within the application such as MST for MASTER, ORD for ORDERS, etc.

O reflects the type of object, such as:
D = Database
S = Schema
T = Table
V = View
X = Index
C = Constraint

M is for multiple occurences.

The CUStomer ORDers Table is CUSORDT.

The CUStomer ORDers inDeXes are CUSORDX1 and CUSORDX2.

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
…

All object names must be unique or implicitly or explicitly qualified by the next higher object and can not be SQL reserved words.

The vendors’ specifications vary from the rules specified by the SQL2003 standard.