Creating SQL Objects › Creating a Schema › Naming the Schema

Naming the Schema

The name you enter after the AUTHORIZATION keyword in the CREATE SCHEMA statement is the name of the schema and is used as an authorization ID for SQL objects (tables, views, synonyms) owned by that schema. The schema name, or authorization ID (AUTHID), must be 1 to 18 characters in length. CA Datacom Datadictionary uses this SQL name as the name of the AUTHORIZATION occurrence which is defined to the CA Datacom Datadictionary. The name must be unique for all AUTHORIZATION occurrences. You cannot create a schema which has the same name as an existing AUTHORIZATION occurrence in CA Datacom Datadictionary.