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: 08/29/2024