SQL Table

Table-Naming Standards
Table-naming standards, as well as any standard within a business, are critical to
maintaining control. After studying the tables and data in the previous sections, you
probably noticed that each table’s suffix is _TBL. This is a naming standard selected
for use, such as what’s been used at various client sites. The _TBL simply tells you
that the object is a table; there are many different types of objects in a relational
database. For example, you will see that the suffix _INX is used to identify indexes
on tables in later hours. Naming standards exist almost exclusively for overall
organization and assist immensely in the administration of any relational database.
Remember, the use of a suffix is not mandatory when naming database objects.