---
title: Get metadata about MySQL databases
kind: blog
description: Just a short reminder for myself...
words: 0
readingMinutes: 1
created: '2009-12-05T08:06:07.000Z'
updated: '2026-06-27T21:03:45+02:00'
tags:
  - mysql
  - development
---
```sql
SHOW DATABASES;  
SHOW TABLES;  
SHOW CREATE TRIGGER  <trigger-name>  
SHOW CREATE PROCEDURE <procedure-name>
```