This is a read-only copy of the MariaDB Knowledgebase generated on 2024-05-20. For the latest, interactive version please visit https://mariadb.com/kb/.

SHOW TABLE STATUS

Sintassi

SHOW TABLE STATUS [FROM nome_db]
    [LIKE 'pattern' | WHERE espre]

Description:

SHOW TABLE STATUS funziona come SHOW TABLES, ma fornisce molte più informazioni sulle tabelle non temporanee. E' possibile ottenerle anche utilizzando il comando mysqlshow --status db_name. La clausola LIKE, se presente, restituisce solo le tabelle i cui nomi corrispondono al pattern. La clausola WHERE può essere usata per specificare condizioni più generiche, come spiegato in http://dev.mysql.com/doc/refman/5.1/en/extended-show.html.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.