Class CIM_SqlSchema
extends CIM_SqlObject

An SQL-schema is a persistent descriptor that includes: - The name of the SQL-schema. - The <authorization identifier> of the owner of the SQL -schema. - The name of the default character set for the SQL-schema. - The <schema path specification> defining the SQL-path for SQL-invoked routines for the SQL-schema. - The descriptor of every component of the SQL-schema. The persistent objects described by the descriptors are said to be owned by or to have been created by the <authorization identifier> of the schema. Each component descriptor is one of: - A domain descriptor. - A base table descriptor. - A view descriptor. - A constraint descriptor. - A privilege descriptor. - A character set descriptor. - A collation descriptor. - A transliteration descriptor. - A user-defined type descriptor. - A routine descriptor. - A sequence generator descriptor. A schema is created initially using a <schema definition> and may be subsequently modified incrementally over time by the execution of <SQL schema statement> s. <schema name> s are unique within a catalog. A <schema name> is explicitly or implicitly qualified by a <catalog name> that identifies a catalog. Base tables and views are identified by <table name> s. A <table name> consists of a <schema name> and an <identifier>. The <schema name> identifies the schema in which a persistent base table or view identified by the <table name> is defined. Base tables and views defined in different schemas can have <identifier> s that are equal. If a reference to a <table name> does not explicitly contain a <schema name>, then a specific <schema name> is implied. The particular <schema name> associated with such a <table name> depends on the context in which the <table name> appears and is governed by the rules for <schema qualified name>. If a reference to an SQL-invoked routine that is contained in a <routine invocation> does not explicitly contain a <schema name>, then the SQL-invoked routine is selected from the SQL -path of the schema. The containing schema of an <SQL schema statement> is defined as the schema identified by the <schema name> implicitly or explicitly contained in the name of the object that is created or manipulated by that SQLstatement.

Table of Contents
Hierarchy
Direct Known Subclasses
Class Qualifiers
Class Properties
Class Methods


Class Hierarchy

CIM_ManagedElement
   |
   +--CIM_ManagedSystemElement
   |
   +--CIM_LogicalElement
   |
   +--CIM_SqlObject
   |
   +--CIM_SqlSchema

Direct Known Subclasses

Class Qualifiers

NameData TypeValue
DescriptionstringAn SQL-schema is a persistent descriptor that includes: - The name of the SQL-schema. - The <authorization identifier> of the owner of the SQL -schema. - The name of the default character set for the SQL-schema. - The <schema path specification> defining the SQL-path for SQL-invoked routines for the SQL-schema. - The descriptor of every component of the SQL-schema. The persistent objects described by the descriptors are said to be owned by or to have been created by the <authorization identifier> of the schema. Each component descriptor is one of: - A domain descriptor. - A base table descriptor. - A view descriptor. - A constraint descriptor. - A privilege descriptor. - A character set descriptor. - A collation descriptor. - A transliteration descriptor. - A user-defined type descriptor. - A routine descriptor. - A sequence generator descriptor. A schema is created initially using a <schema definition> and may be subsequently modified incrementally over time by the execution of <SQL schema statement> s. <schema name> s are unique within a catalog. A <schema name> is explicitly or implicitly qualified by a <catalog name> that identifies a catalog. Base tables and views are identified by <table name> s. A <table name> consists of a <schema name> and an <identifier>. The <schema name> identifies the schema in which a persistent base table or view identified by the <table name> is defined. Base tables and views defined in different schemas can have <identifier> s that are equal. If a reference to a <table name> does not explicitly contain a <schema name>, then a specific <schema name> is implied. The particular <schema name> associated with such a <table name> depends on the context in which the <table name> appears and is governed by the rules for <schema qualified name>. If a reference to an SQL-invoked routine that is contained in a <routine invocation> does not explicitly contain a <schema name>, then the SQL-invoked routine is selected from the SQL -path of the schema. The containing schema of an <SQL schema statement> is defined as the schema identified by the <schema name> implicitly or explicitly contained in the name of the object that is created or manipulated by that SQLstatement.
Experimentalbooleantrue
UMLPackagePathstringCIM::Database::Sql
Versionstring2.12.0

Class Properties

Local Class Properties

NameData TypeDefault ValueQualifiers
NameData TypeValue
Ownerstring
DescriptionstringThe <authorization identifier> of the owner of the SQL -schema.

Inherited Properties

NameData Type
Captionstring
CommunicationStatusuint16
CreationTimedatetime
Descriptionstring
DetailedStatusuint16
ElementNamestring
Generationuint64
HealthStateuint16
InstallDatedatetime
InstanceIDstring
Namestring
OperatingStatusuint16
PrimaryStatusuint16
Statusstring
OperationalStatusuint16[]
StatusDescriptionsstring[]

Class Methods