Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-tables-extensions-table.html
The TABLES_EXTENSIONS table provides information about table attributes defined for primary and secondary storage engines. The TABLES_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-table-id-table.html
The rpd_table_id table provides the ID, name, and schema of the tables loaded in MySQL HeatWave. The rpd_table_id table has these columns: ID A unique identifier for the table. MATERIALIZATION_QUERY Available as of MySQL 9.3.0, contains the query ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: CONSTRAINT_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-view-table-usage-table.html
The VIEW_TABLE_USAGE table provides access to information about tables and views used in view definitions. You can see information only for views for which you have some privilege, and only for tables for which you have some privilege. The ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-rpd-table-id-table.html
The rpd_table_id table provides the ID, name, and schema of the tables loaded in the MySQL AI Engine. The rpd_table_id table has these columns: ID A unique identifier for the table.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-table-grants-table.html
The ROLE_TABLE_GRANTS table provides information about the table privileges for roles that are available to or granted by the currently enabled roles. The ROLE_TABLE_GRANTS table has these columns: GRANTOR The user name part of the account that ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-constraints-table.html
The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. CONSTRAINT_SCHEMA The name of the schema (database) ...
https://dev.mysql.com/doc/refman/8.4/en/optimize-table.html
OPTIMIZE TABLE reorganizes the physical storage of table data and associated index data, to reduce storage space and improve I/O efficiency when accessing the table. The exact changes made to each table depend on the storage engine used by that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-operations.html
Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL ...