SQL editor for MySQL
[EN]
List of tables in the selected MySQL/MariaDB database
SQL queries
List of tables in the database
select table_name
from information_schema.TABLES
where Upper(table_schema)=Upper($$DATABASE)
and TABLE_TYPE in ('BASE TABLE','SYSTEM VIEW')
order by 1
COLUMN - list of columns in the table with data types
select column_name, data_type
from information_schema.COLUMNS
where table_schema= $$DATABASE_NAME
and table_name = $$TABLE_NAME
order by ordinal_position
[RU]
Список таблиц в выбранной базе данных MySQL/MariaDB
SQL запросы
Список таблиц в базе
select table_name
from information_schema.TABLES
where Upper(table_schema)=Upper($$DATABASE)
and TABLE_TYPE in ('BASE TABLE','SYSTEM VIEW')
order by 1
COLUMN - список колонок в таблице с типами данных
select column_name, data_type
from information_schema.COLUMNS
where table_schema= $$DATABASE_NAME
and table_name = $$TABLE_NAME
order by ordinal_position