Table Naming Conventions

Across the applications, a common naming convention is to name a table with the singular form of the underlying data. For instance, if the table is meant to store a data set representing customers, name the table “Customer.” Additionally, prefixes are commonly attached to the table name. “zt” represents application configuration data, whereas “tt” represents expected user data. Configuration data may include user data, but it’s still utilized by the application as configuration. For the Customer example, the full table name is “ttCustomer.” This allows developers to quickly identify and filter tables to learn and develop the application further.

Refer to Create Tables in SQL for general information.

When naming tables:

  • Consistently name tables with small data prefix (2 characters) followed by a descriptive name of the contents of the table.
  • Capitalize the first letter of each word, if multiple words are used in the table name, e.g., OrderDetail.
  • Do not abbreviate.
  • Use singular table names.
  • Do not use hyphens (“-“), spaces or slashes (“/”, “\”) in the table name. Underscores are acceptable.

**NOTE:  ** Special characters in SQL Object names will break functionality in DSP®.

The following table outlines the basic table naming conventions: