mysql_legacy_list_tables
List all base tables and views in a specified MySQL database using SHOW FULL TABLES. Pass the database name to retrieve its schema objects.
Instructions
Lists base tables and views in one database via SHOW FULL TABLES FROM database. Pass database. For column types use mysql_legacy_describe_table; for CREATE TABLE text use mysql_legacy_show_create_table; for keys use mysql_legacy_list_indexes. To list databases first, use mysql_legacy_list_databases.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | MySQL database name, 1–64 characters. |