Was this helpful?
Object Names
The rules for naming database objects (such as tables, columns, views, and database procedures) created using QUEL are as follows:
Names can contain only alphanumeric characters, and must begin with an alphabetic character or an underscore (_).
Names can contain (though not begin with) the following special characters: "0" through "9", "#," "@," and "$".
Table names cannot begin with "ii". These names are reserved for use by the DBMS Server.
The maximum length of names for the following objects is 256 bytes:
Table
Column
Partition
Procedure
Procedure parameter
Rule
Sequence
Synonym
Object
Constraint
In an installation that uses the UTF8 or any other multi-byte character set, the maximum length of a name may be less than 256 bytes because some glyphs use multiple bytes.
The maximum length of names for the following objects is 32 bytes:
Owner
User
Group
Profile
Role
Schema
Location
Event
Alarm
Node
Objects managed by the Ingres interfaces such as Query-By-Forms, Report-By-Forms, Vision, and Visual Forms Editor (for example: Forms, JoinDefs, QBFnames, Graphs, Reports)
The maximum length of a name for a collation sequence is 64 bytes.
The maximum length of an object name in ANSI/ISO Entry SQL-92 compliant databases is 18 bytes.
Avoid assigning reserved words as object names.
Last modified date: 01/30/2023