AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Datagrip not showing tables1/10/2023 Lists all virtual schemas and shows the properties which are specific to virtual schemas. Lists the properties of all virtual schemas in the database. It contains the information which are specific to virtual columns. Provides complete information on all of the users known to the system. Shows the system privileges granted to all users and roles. Shows all sessions and associated resources limits known to the system.Ĭontains complete information on open sessions of any database user. List of all roles granted to a user or a role. Lists all connection objects to which certain, restricted scripts were granted access to. The values are calculated recursively, that is, the size of a schema includes the total of all of the sizes of the schema objects contained within. Lists the specific privileges who can impersonate whom.Ĭontains all of the object privileges granted for objects in the database.Ĭontains the sizes of all database objects. Lists all the direct and indirect dependencies between schema objects (thus recursive). Lists all the direct dependencies between schema objects. Lists all connections which were granted to the user or one of their roles.Ĭontains information about referenced table columns of all constraints of the database.Ĭontains information about all constraints of the database. Lists the compressed and raw sizes of all columns in all user tables in all schemas.Ĭontains information on all table columns. Lists all the consumer groups known to the system. This system table contains information about the clusters currently active. This system table lists all contents of SSD cache of all nodes. It contains the information which are specific to virtual tables. Lists all virtual tables to which the current user has access. Lists all virtual schemas to which the current user has access and shows the properties which are specific to virtual schemas. It contains the information which are specific to virtual columns.Ĭontains information on the properties of all virtual schemas to which the current user has access. Lists all columns of virtual tables to which the current user has access. Lists all of the views accessible to the current user. Provides restricted information on all of the users known to the system. Lists all the schemas to which the current user has access.ĭescribes all scripts of the database to which the current user has access.Ĭontains restricted information on open sessions of any database user.ĭescribes all of the tables in the database to which the current user has access. Lists all objects in the current schema to which the current user has access. Lists all object privileges granted to the user directly or through PUBLIC.Ĭontains the sizes of all of the database objects to which the current user has access.ĭescribes all of the database objects to which the current user has access. Lists all object privileges that are self-assigned by the user or those on objects that belong to the user. Lists all direct dependencies between schema objects to which the current user has access.ĭescribes all functions of the database to which the current user has access.ĭescribes all indices on tables to which the current user has access.Ĭontains all of the object privileges granted for objects in the database to which the current user has access. Lists the compressed and raw sizes of all columns in all user tables in all schemas to which the current user has accessĬontains information about referenced table columns of all constraints to which the current user has access.Ĭontains information about constraints of tables to which the current user has access. System Table NameĬontains information on all the table columns to which the current user has access. Click the table name to view its details. The following table provides you with a list of all the metadata system tables in Exasol. This means that the tables in the system schemas can be accessed without specifying the schema as long as the same table name is not in use in the current schema. The system schemas SYS and EXA_STATISTICS are automatically integrated into the namespace. The metadata system tables provide information about the metadata of the database.
0 Comments
Read More
Leave a Reply. |