Quick Beginnings for DB2 Connect

Object Name Rules

Database objects include:

• Tables

• Views

• Columns

• Indexes

• User-defined functions (UDFs)

• User-defined types (UDTs)

• Triggers

• Aliases

• Table spaces

• Schemas

When naming database objects, see General Naming Rules.

In addition, the name you specify:

• Can contain 1 to 18 characters except for the following:

  • Table names (including view names, summary table names, alias names, and correlation names), which can contain up to 128 characters; and

  • column names, which can contain up to 30 characters

• Cannot be any of the SQL reserved words that are listed in the SQL Reference.

Using delimited identifiers, it is possible to create an object that violates these naming rules; however, subsequent use of the object could result in errors. For example, if you create a column with a + or - sign included in the name and you subsequently use that column in an index, you will experience problems when you attempt to reorganize the table. To avoid potential problems with the use and operation of your database, do not violate these rules.

[ DB2 List of Books | Search the DB2 Books ]