Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY table. The LIKE clause, if present, indicates which table names to match. You ...
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. The column contains the query used to create the MySQL HeatWave ...
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/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.5/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/heatwave/en/mys-hw-genai-byo-embedding-tables.html
As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector search. The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as ...A vector column containing the vector embeddings of the text ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description of your table. If you start the MySQL server with external locking ...The output from these commands is explained later in this ...
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) ...