INFORMATION.SCHEMA Namespace Reference

Documentation for the INFORMATION.SCHEMA package. More...

Classes
class	CHECKCONSTRAINTS
	Returns one row for each check constraint in the current namespace for tables that can be accessed by the current user in the current namespace. More...
class	COLUMNHISTOGRAMS
class	COLUMNS
	Returns one row for each column that can be accessed by the current user in the current namespace. More...
class	CONSTRAINTCOLUMNUSAGE
	Returns one row for each column for each CHECK, UNIQUE, PRIMARY KEY, FOREIGN KEY constraint, or assertion in the current namespace for tables that can be accessed by the current user in the current namespace. More...
class	CONSTRAINTTABLEUSAGE
	Returns one row for each table that has a constraint defined on the table, for tables that can be accessed by the current user in the current namespace. More...
class	CURRENTCONNECTIONS
	Returns one row for each xDBC server process currently running on this instance Column Descriptions: More...
class	CURRENTSTATEMENTS
	Returns one row for each metadata string pushed onto the Application Metadata Stack (AMS) that belongs to the SQL application (ApplicationID="%SQL" [WHERE "%SQL"=$$$AMSApplicationIDSQL]). More...
class	FOREIGNSERVERS
	This table has one row for each Foreign Server the users is privileged for in the current namespace. More...
class	FOREIGNTABLES
	This table has one row for each Foreign Table the users is privileged for in the current namespace. More...
class	INDEXES
	Returns one row for each indexed field in the current namespace for tables that can be accessed by the current user in the current namespace. More...
class	KEYCOLUMNUSAGE
	Returns one row for each columns for each UNIQUE, PRIMARY KEY, or FOREIGN KEY table constraint in the current namespace for tables that can be accessed by the current user in the current namespace. More...
class	MLMODELS
	Returns one row for each Integrated ML Model that can be accessed by the current user in the current namespace. More...
class	MLTRAINEDMODELS
	Returns one row for each Integrated ML Trained Model that can be accessed by the current user in the current namespace. More...
class	MLTRAININGRUNS
	Returns one row for each Integrated ML Training Run that can be accessed by the current user in the current namespace. More...
class	MLVALIDATIONMETRICS
	Returns one row for each Integrated ML Validation Metric that can be accessed by the current user in the current namespace. More...
class	MLVALIDATIONRUNS
	Returns one row for each Integrated ML Validation Run that can be accessed by the current user in the current namespace. More...
class	PARAMETERS
	The PARAMETERS table has one row for each SQL parameter of each SQL-invoked routine (procedure) described in the ROUTINES base table for which the current user has privileges for. More...
class	REFERENTIALCONSTRAINTS
	Returns one row for each FOREIGN KEY table constraint in the current namespace for tables that can be accessed by the current user in the current namespace. More...
class	ROUTINES
	Returns one row for each stored procedure and function that can be accessed by the current user in the current namespace. More...
class	SCHEMATA
	Returns one row for each schema in the current namespace where the current user has privileges for any object in the namespace. More...
class	STATEMENTCHILDREN
	Child table of INFORMATION_SCHEMA.STATEMENTS which contains hash of the root parallel statement if this is a parallel "child" statement. More...
class	STATEMENTDAILYSTATS
	Per day light weight statistics of this SQL statement. More...
class	STATEMENTHOURLYSTATS
	Per hour light weight statistics of this SQL statement. More...
class	STATEMENTLOCATIONS
	Returns one row location (routine, class) that has an SQL Statement. More...
class	STATEMENTPARAMETERSTATS
	Daily parameter statistics of this SQL statement. More...
class	STATEMENTPRIVACTIONS
	Child class of INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS, the privilege actions required for the parent SQL object for this statement. More...
class	STATEMENTPRIVOBJECTS
	Child class of INFORMATION.SCHEMA.STATEMENTS, the SQL Objects that have privileges required for this statement. More...
class	STATEMENTRELATIONS
	Child table of INFORMATION_SCHEMA.STATEMENTS which contains each table or view entry use by the statement. More...
class	STATEMENTS
	Contains SQL Statement Index entries that can be accessed by the current user in the current namespace. More...
class	TABLECONSTRAINTS
	Returns one row for each table constraint in the current namespace for tables that can be accessed by the current user in the current namespace. More...
class	TABLES
	Returns one row for each table in the current namespace for which the current user has privileges. More...
class	TRIGGERS
	Returns one row for each trigger for tables that can be accessed by the current user in the current namespace. More...
class	USERDEFINEDAGGREGATES
	Returns one row for each user defined aggregate that can be accessed by the current user in the current namespace. More...
class	VIEWCOLUMNUSAGE
	Returns one row for each table column that is used in a view where the view and view column can be accessed by the current user in the current namespace. More...
class	VIEWS
	Returns one row for each view in the current namespace for which the current user has privileges. More...
class	VIEWTABLEUSAGE
	Returns one row for each table in the current namespace where the table is used by a view, and the current user has privileges for the table and view. More...

Detailed Description

Documentation for the INFORMATION.SCHEMA package.