Object Names in 602SQL
A 602SQL object can be a table, query, diagram, procedure, etc. Each object has a name that is used to access the object. The following rules apply to object names:
- A name may have a maximum of 31 characters, beginning with a letter or an underscore.
- May contain numbers, letters and the underscore character. National alphabet character are also acceptable.
- Names are not case-sensitive. Blank spaces at the beginning and end of a name are truncated.
- Objects of the same category in the same application may not have the same name (even if in different folders). It is not recommended to enter the same name for a table and a query. This may cause problems with some client interfaces. Users and groups are unique for the entire database.
You can bypass the first two rules when you enclose the name in grave accent characters "`" when referring to this object (e.g. `My new table#3`). Grave accents may never be part of an object name. Some client interfaces may have trouble handling objects with these names.
The object name is an integral part of the object definition stored in the system tables: TABTAB (tables), USERTAB (users and groups) and OBJTAB (other objects).
Database names and remote server names are stored in the registry (Windows) or in an INI file (Linux). The constraints described above are not used here (only uniqueness preservation).
