# Типы таблиц (ENGINE)

{% tabs %}
{% tab title="SQL" %}
```sql
SELECT TABLE_NAME,ENGINE,ROW_FORMAT,TABLE_ROWS,DATA_LENGTH,INDEX_LENGTH FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'db_name' ORDER BY ENGINE asc;
```
{% endtab %}
{% endtabs %}

