Administering Satellites Guide and Reference

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
Note: The names of all tables and columns that are used for data replication can contain up to 18 characters.
Cannot be any of the SQL reserved words that are listed in the SQL Reference.

Note:

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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ Top of Page ]