Schemata schema collection returns information about DATABASE objects by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.DATABASES[V] or DBC.DATABASES[V]X Data Dictionary views based on UseXViews Connection setting.

Column Name	Data Type	Description
CATALOG_NAME	String	This field is always set to EMPTY.
SCHEMA_NAME	String	Returns the name of the DATABASE object.
SCHEMA_OWNER	String	Returns the name of the DATABASE owner.
DEFAULT_CHARACTER_SET_CATALOG	String	This field is always set to NULL.
DEFAULT_CHARACTER_SET_SCHEMA	String	This field is always set to NULL.
DEFAULT_CHARACTER_SET_NAME	String	This field is always set to NULL.

Schemata schema collection can be filtered or restricted to:

Restriction Column Name	Restriction Number	Description
SCHEMA_NAME	1	This restriction can be set to a valid DATABASE object name.
SCHEMA_OWNER	2	This restriction can be set to a valid DATABASE Owner.

Schemata schema collection rows are ordered by:

Column Name	Description
SCHEMA_NAME	Ascending case sensitive sort order. For example A through Z followed by a through z.
SCHEMA_OWNER	Ascending case sensitive sort order.