Provides definitions for some of HSQLDB's additional system vies. The definitions for the rest of system vies are provided by DatabaseInformationMain, which this class extends.
| Modifier and Type | Field and Description |
|---|---|
| pack-priv static final String | |
| pack-priv static final OrderedHashMap |
| Access | Constructor and Description |
|---|---|
| pack-priv | DatabaseInformationFull(Database
the database for which to produce system tables. db)Constructs a new DatabaseInformationFull instance. |
| Modifier and Type | Method and Description |
|---|---|
| pack-priv void | |
| pack-priv Table | Returns: TableSQL:2008 VIEW ADMINISTRABLE_ROLE_AUTHORIZATIONS Returns roles that are grantable by an admin user, which means all the roles. |
| pack-priv Table | APPLICABLE_ROLES(Session session, PersistentStore store)
SQL:2008 VIEW APPLICABLE_ROLES Identifies the applicable roles for the current user. |
| pack-priv Table | |
| pack-priv Table | Returns: TableSQL:2008 VIEW SYSTEM_AUTHORIZATIONS The AUTHORIZATIONS table has one row for each <role name> and one row for each <authorization identifier > referenced in the Information Schema. |
| pack-priv Table | |
| pack-priv Table | Returns: TableSQL:2008 VIEW The CHECK_CONSTRAINT_ROUTINE_USAGE view has one row for each SQL-invoked routine identified as the subject routine of either a <routine invocation>, a <method reference>, a <method invocation>, or a <static method invocation> contained in an <assertion definition>, a <domain constraint>, or a <table constraint definition>. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The CHECK_CONSTRAINTS view has one row for each domain constraint, table check constraint, and assertion. |
| pack-priv Table | Returns: TableSQL:2008 VIEW COLLATIONS The COLLATIONS view has one row for each character collation descriptor. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The COLUMN_COLUMN_USAGE view has one row for each column referenced by a GENERATED column. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The COLUMN_DOMAIN_USAGE view has one row for each column defined with a a DOMAIN data type. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The COLUMN_DOMAIN_USAGE view has one row for each column defined with a a DOMAIN data type. |
| pack-priv Table | COLUMNS(Session session, PersistentStore store)
SQL:2008 VIEW The COLUMNS view has one row for each column of each table or view. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The CONSTRAINT_COLUMN_USAGE view has one row for each column identified by a table constraint or assertion. |
| pack-priv Table | Returns: TableSQL:2011 VIEW The CONSTRAINT_PERIOD_USAGE view has one row for each PERIOD referenced by a table constraint or assertion. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The CONSTRAINT_TABLE_USAGE view has one row for each table identified by a <table name> simply contained in a <table reference> contained in the <search condition> of a check constraint, domain constraint, or assertion. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The DATA_TYPE_PRIVILEGES view has one row for each use of a data type. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The DOMAIN_CONSTRAINTS view has one row for each domain constraint. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The DOMAINS view has one row for each domain. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The type attributes of elements of array in columns of tables. |
| pack-priv Table | ENABLED_ROLES(Session session, PersistentStore store)
SQL:2008 VIEW ENABLED_ROLES Identify the enabled roles for the current SQL-session. |
| protected Table | Returns: the system table corresponding to the specified indexindex identifying the system table to generate tableIndex)Overrides org. Retrieves the system table corresponding to the specified index. |
| private void | |
| pack-priv Table | |
| pack-priv Table | |
| pack-priv Table | Returns: aTable object describing the visible
primary key and unique columns of each accessible table
defined within this database.SQL:2008 VIEW The KEY_COLUMN_USAGE view describes the columns of PRIMARY KEY, UNIQUE, FOREIGN KEY, and CHECK constraint of each accessible table defined within this database. |
| pack-priv Table | Returns: aTable object describing the visible periods
referenced in primary key and unique constraints in accessible
tables defined within this database.SQL:2011 VIEW The KEY_PERIOD_USAGE view has one row for each PERIOD referenced in PRIMARY KEY, UNIQUE and FOREIGN KEY constraint of each accessible table defined within this database. |
| pack-priv Table | METHOD_SPECIFICATION_PARAMETERS(Session session, PersistentStore store)
SQL:2008 VIEW The METHOD_SPECIFICATION_PARAMETERS view is not implemented. |
| pack-priv Table | METHOD_SPECIFICATIONS(Session session, PersistentStore store)
SQL:2008 VIEW The METHOD_SPECIFICATIONS view is not implemented. |
| pack-priv Table | MODULE_COLUMN_USAGE(Session session, PersistentStore store)
SQL:2008 VIEW The MODULE_COLUMN_USAGE view is not implemented. |
| pack-priv Table | MODULE_PRIVILEGES(Session session, PersistentStore store)
SQL:2008 VIEW The MODULE_PRIVILEGES view is not implemented. |
| pack-priv Table | MODULE_TABLE_USAGE(Session session, PersistentStore store)
SQL:2008 VIEW The MODULE_TABLE_USAGE view is not implemented. |
| pack-priv Table | |
| pack-priv Table | Returns: TableSQL:2008 VIEW The PARAMETERS view has one row for each parameter of a user defined routine. |
| pack-priv Table | Returns: TableSQL:2011 VIEW The PERIODS view has one row for each period defined in a table. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The REFERENTIAL_CONSTRAINTS view has one row for each FOREIGN KEY constraint. |
| pack-priv Table | Returns: TableROLE_AUTHORIZATION_DESCRIPTORS Contains a representation of all role authorization descriptors. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROLE_COLUMN_GRANTS view has one row for each privilege granted to each ROLE on each column. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROLE_ROUTINE_GRANTS view has one row for each privilege granted to each ROLE on each specific routine. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROLE_ROUTINE_GRANTS view has one row for each privilege granted to each ROLE on each table. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROLE_UDT_GRANT view has one row for each privilege granted to each user defined type. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROLE_USAGE_GRANTS view has one row for each privilege granted to each ROLE on each table. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROUTINE_COLUMN_USAGE view has one row for each column referenced in the body of a routine. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROUTINE_JAR_USAGE view has one row for each jar archive referenced in the body of a Java routine. |
| pack-priv Table | Returns: TableSQL:2011 VIEW The ROUTINE_PERIOD_USAGE view has one row for each PERIOD referenced in the body of a routine. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROUTINE_PRIVILEGES view has one row for each privilege granted on a PROCEDURE or CATALOG. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROUTINE_ROUTINE_USAGE view has one row for each routine referenced in the body of a routine. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROUTINE_SEQUENCE_USAGE view has one row for each SEQUENCE referenced in the body of a routine. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The ROUTINE_TABLE_USAGE view has one row for each TABLE referenced in the body of a routine. |
| pack-priv Table | ROUTINES(Session session, PersistentStore store)
SQL:2008 VIEW The ROUTINES view has one row for each PROCEDURE and FUNCTION. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The SCHEMATA view has one row for each accessible schema. |
| pack-priv Table | SQL_FEATURES(Session session, PersistentStore store)
SQL:2008 VIEW The SQL_FEATURES view lists the individual features of the SQL Standard supported by HyperSQL. |
| pack-priv Table | SQL_IMPLEMENTATION_INFO(Session session, PersistentStore store)
SQL:2008 VIEW The SQL_IMPLEMENTATION_INFO shows some properties and capabilities of the database engine . |
| pack-priv Table | SQL_PACKAGES(Session session, PersistentStore store)
SQL:2008 VIEW The SQL_PACHAGES view lists the packages of the SQL Standard supported by HyperSQL. |
| pack-priv Table | SQL_PARTS(Session session, PersistentStore store)
SQL:2008 VIEW The SQL_PARTS view lists the parts of the SQL Standard supported by HyperSQL. |
| pack-priv Table | SQL_SIZING(Session session, PersistentStore store)
SQL:2008 VIEW The SQL_SIZING view has one row for the maximum size of each built in type supported by HyperSQL. |
| pack-priv Table | SQL_SIZING_PROFILES(Session session, PersistentStore store)
SQL:2008 VIEW The SQL_SIZING_PROFILES is empty. |
| pack-priv Table | Returns: a description of the current state of all row caching objects associated with the accessible tables of the databaseSQL:2008 VIEW
Retrieves a |
| pack-priv Table | |
| pack-priv Table | |
| pack-priv Table | Returns: aTable object describing the visible
Index objects for each accessible
table defined within this database.Retrieves a |
| pack-priv Table | SYSTEM_KEY_INDEX_USAGE(Session session, PersistentStore store)
The SYSTEM_KEY_INDEX_USAGE view has one row for each unique, primary or foreign key constraint of each accessible table for which the current authorization has has some privilege on each column of the constraint. |
| pack-priv Table | Returns: table describing database operating parametersRetrieves a |
| pack-priv Table | Returns: aTable object describing the
attributes of the connection associated
with the current execution contextRetrieves a |
| pack-priv Table | Returns: aTable object describing all visible
sessionsRetrieves a |
| pack-priv Table | |
| pack-priv Table | |
| pack-priv Table | Returns: aTable object describing the text attributes
of the accessible text tables defined within this databaseRetrieves a |
| pack-priv Table | Returns: TableThe TABLE_CONSTRAINTS table has one row for each table constraint associated with a table. |
| pack-priv Table | TRANSLATIONS(Session session, PersistentStore store)
SQL:2008 VIEW The TRANSLATIONS view has one row for each translation between two character sets. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The TRIGGER_COLUMN_USAGE view has one row for each column referenced in the body of a trigger. |
| pack-priv Table | Returns: TableSQL:2011 VIEW The TRIGGER_PERIOD_USAGE view has one row for each PRDIOD referenced in the body of a trigger. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The TRIGGER_ROUTINE_USAGE view has one row for each routine referenced in the body of a trigger. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The TRIGGER_SEQUENCE_USAGE view has one row for each SEQUENCE referenced in the body of a trigger. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The TRIGGER_TABLE_USAGE view has one row for each TABLE referenced in the body of a trigger. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The TRIGGERED_UPDATE_COLUMNS view has one row for each column referenced in the optional column list of a UPDATE trigger. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The TRIGGERS view has one row for each TRIGGER. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The UDT_PRIVILEGES view has one row for each privilege granted on a DISTINCT TYPE. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The USAGE_PRIVILEGES view has one row for each usage privilege descriptor. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The USER_DEFINED_TYPES view has one row for each user defined type. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The VIEW_COLUMN_USAGE view has one row for each column of a table that is explicitly or implicitly referenced in the <query expression> of the view being described. |
| pack-priv Table | Returns: TableSQL:2011 VIEW The VIEW_PERIOD_USAGE view has one row for each period contained in the <query expression> of a view. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The VIEW_ROUTINE_USAGE view has one row for each SQL-invoked routine identified as the subject routine of either a <routine invocation>, a <method reference>, a <method invocation>, or a <static method invocation> contained in a <view definition>. |
| pack-priv Table | Returns: TableSQL:2008 VIEW The VIEW_TABLE_USAGE view has one row for each table identified by a <table name> simply contained in a <table reference> that is contained in the <query expression> of a view. |
| pack-priv Table | Returns: a tabular description of the text source of allView objects accessible to
the user.SQL:2008 VIEW The VIEWS view contains one row for each VIEW definition. |