Understanding the Terminology › Schema

Schema

In SQL Mode, when a user is added with a private SQL authorization specified, CA Dataquery automatically creates a schema in CA Datacom Datadictionary for the SQL authorization ID. A schema defines the individual user's SQL environment. A schema contains all table, view, and privilege definitions owned by a given authorization ID.