If you specify the multischema attribute for your database, you can store data definitions in multiple schemas within that database. To specify the multischema attribute, use the MULTISCHEMA IS ON clause in a CREATE DATABASE or ALTER DATABASE statement. If you want SQL behavior compliant with the ANSI/ISO standard, you must specify the multischema attribute. Databases that contain multiple schemas must organize the schemas within one or more catalogs. To refer to data definitions in a multischema database, qualify the names of data definitions with the schema and catalog names and, optionally, qualify with an alias. When you use an alias to qualify the name of a catalog, schema, or object in a multischema database: o Separate subordinate names from the alias and from each other with a period (.) after each name. o Use double quotation marks (") to delimit the leftmost name pair. o Use only uppercase characters in the leftmost name pair. The leftmost name pair in a qualified name for a multischema object is a delimited identifier. In an object name, each qualifying name is considered one level, and names with more than three levels are not allowed. However, a delimited identifier is interpreted as a single level.