Get the MySQL database schema using SQL

L'Antre du Tryphon

schedule
2024-08-24 | 15:16h
update
2024-08-24 | 15:16h
person
www.ctheroux.com
domain
www.ctheroux.com

Get the MySQL database schema using SQL

A complete database schema can be retrieved using the following MySQL statement from the information_schema database:

SELECT * FROM SCHEMATA LEFT JOIN tables ON table_schema = schema_name LEFT JOIN columns ON tables.table_name = columns.table_name WHERE schema_name = '<DATABASE_NAME>'; 

Advertisement

Imprint
Responsible for the content:
www.ctheroux.com
Privacy & Terms of Use:
www.ctheroux.com
Mobile website via:
WordPress AMP Plugin
Last AMPHTML update:
05.01.2026 - 06:28:57
Privacy-Data & cookie usage: