---
mapped_pages:
  - https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-commands.html
---

# SQL commands [sql-commands]

This section contains the list of SQL commands supported by Elasticsearch SQL along with their syntax:

[DESCRIBE TABLE](/reference/query-languages/sql/sql-syntax-describe-table.md)
:   Describe a table.

[SELECT](/reference/query-languages/sql/sql-syntax-select.md)
:   Retrieve rows from zero or more tables.

[SHOW CATALOGS](/reference/query-languages/sql/sql-syntax-show-catalogs.md)
:   List available catalogs.

[SHOW COLUMNS](/reference/query-languages/sql/sql-syntax-show-columns.md)
:   List columns in table.

[SHOW FUNCTIONS](/reference/query-languages/sql/sql-syntax-show-functions.md)
:   List supported functions.

[SHOW TABLES](/reference/query-languages/sql/sql-syntax-show-tables.md)
:   List tables available.