Administration Guide

Object Names

Database objects include the following:

• Schemas
• Tables
• Views
• Columns
• Indexes
• User-defined functions (UDFs)
• User-defined types (UDTs)
• Triggers
• Aliases
• Table spaces
• Stored procedures
• Nodegroups
• Buffer pools
• Event monitors

When naming database objects, the name you specify:

• Can contain 1 to 18 characters (bytes)

  Note:

  Schemas are an exception: They can only allow 1 to 8 characters.

• Must begin with one of the following:
  • A through Z (converts lowercase letters to uppercase)
  • A valid accented letter (such as ö)
  • A multibyte character, except multibyte spaces (for multibyte environments)

• Other characters can include:
  • A through Z (converts lowercase letters to uppercase)
  • A valid accented letter (such as ö)
  • 0 through 9
  • @, #, $, and _ (underscore)
  • Multibyte characters, except multibyte spaces (for multibyte environments)

• Keywords can be used. If the keyword is used in a context where it could also be interpreted as an SQL keyword, it must be specified as a delimited identifier. Refer to the SQL Reference for information on delimited identifiers.

• For maximum portability, use the IBM SQL and ISO/ANSI SQL92 reserved words. For a list of these words, refer to the SQL Reference manual.

Notes:

1. Using delimited identifiers, it is possible to create an object that violates these naming rules; however, subsequent use could lead to error situations. To avoid potential problems with the use and operation of your database, do not violate the above rules.

   For example, if you created 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.

2. For information about National Language Support (NLS) related to object names, see Appendix O. "National Language Support (NLS)".

[ DB2 List of Books | Search the DB2 Books ]