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:
– Procedure parameter
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:
– 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.