Naming Objects

Go Up to Designing Databases

Valid names for InterBase objects must use the 7-bit ASCII character set (character set ID 2) and must have the following characteristics:

• no spaces
• not case sensitive
• not InterBase keywords
• a maximum of 68 bytes long: 67 bytes plus a null terminator

Using delimited identifiers you create metadata names that are case sensitive, can contain spaces, and can be InterBase keywords by placing them double quotes. Such names in double quotes are called delimited identifiers.

Tip: When you use an object name without double quotes, InterBase maps all the characters to uppercase. For example, if you create a table with a double-quote delimited name in all uppercase, you can use the name subsequently without double quotes. For example:

CREATE TABLE “UPPERCASE_NAME”...
SELECT * FROM UPPERCASE_NAME;