> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/commands",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference for SQL commands and operators in Firebolt.

# SQL commands

Use the alphabetical list in the navigation pane to find the syntax for commands that you already know.

Use the functional list below to find commands for a specific task area that you're working in.

* [Queries](#queries)
  Analyze data with `SELECT`. Tune and optimize query performance with other commands.

* [Data management](#data-management)
  Move data between your data lake and Firebolt and between Firebolt resources.

* [Data definition](#data-definition)
  Data definition language. Create, alter, drop, and otherwise manage objects like databases, tables, and views in your Firebolt account.

* [Engines](#engines)
  Start, stop, and manage Firebolt engines.

* [Metadata](#metadata)
  Query the Firebolt information schema for metadata related to its objects and resources.

* [Access control](#access-control)
  Access control language. Create, alter and drop, and otherwise manage users, logins, service accounts and roles.

## Queries

* [Cross-database queries](/reference-sql/commands/queries/cross-database-queries)
* [EXPLAIN](/reference-sql/commands/queries/explain)
* [RECOMMEND DDL](/reference-sql/commands/queries/recommend_ddl)
* [SELECT](/reference-sql/commands/queries/select)

## Data management

* [COPY FROM](/reference-sql/commands/data-management/copy-from)
* [COPY TO](/reference-sql/commands/data-management/copy-to)
* [DELETE](/reference-sql/commands/data-management/delete)
* [INSERT](/reference-sql/commands/data-management/insert)
* [MERGE](/reference-sql/commands/data-management/merge)
* [TRUNCATE TABLE](/reference-sql/commands/data-management/truncate-table)
* [UPDATE](/reference-sql/commands/data-management/update)
* [VACUUM](/reference-sql/commands/data-management/vacuum)

## Data definition

* [ALTER ACCOUNT](/reference-sql/commands/data-definition/alter-account)
* [ALTER DATABASE](/reference-sql/commands/data-definition/alter-database)
* [ALTER TABLE](/reference-sql/commands/data-definition/alter-table)
* [CREATE ACCOUNT](/reference-sql/commands/data-definition/create-account)
* [CREATE AGGREGATING INDEX](/reference-sql/commands/data-definition/create-aggregating-index)
* [CREATE VECTOR SEARCH INDEX](/reference-sql/commands/data-definition/create-vector-search-index)
* [CREATE DATABASE](/reference-sql/commands/data-definition/create-database)
* [CREATE EXTERNAL TABLE](/reference-sql/commands/data-definition/create-external-table)
* [CREATE FACT or DIMENSION TABLE](/reference-sql/commands/data-definition/create-fact-dimension-table)
* [CREATE VIEW](/reference-sql/commands/data-definition/create-view)
* [DROP ACCOUNT](/reference-sql/commands/data-definition/drop-account)
* [DROP DATABASE](/reference-sql/commands/data-definition/drop-database)
* [DROP INDEX](/reference-sql/commands/data-definition/drop-index)
* [DROP TABLE](/reference-sql/commands/data-definition/drop-table)
* [DROP VIEW](/reference-sql/commands/data-definition/drop-view)
* [USE DATABASE](/reference-sql/commands/data-definition/use-database)
* [EXPLICIT TRANSACTIONS](/reference-sql/explicit-transactions)

## Engines

* [ALTER ENGINE](/reference-sql/commands/engines/alter-engine)
* [CREATE ENGINE](/reference-sql/commands/engines/create-engine)
* [DROP ENGINE](/reference-sql/commands/engines/drop-engine)
* [START ENGINE](/reference-sql/commands/engines/start-engine)
* [STOP ENGINE](/reference-sql/commands/engines/stop-engine)
* [USE ENGINE](/reference-sql/commands/engines/use-engine)
* [CLEAR CACHE](/reference-sql/commands/engines/clear-cache)

## Metadata

* [DESCRIBE](/reference-sql/commands/metadata/describe)
* [SHOW CACHE](/reference-sql/commands/metadata/show-cache)
* [SHOW CATALOGS](/reference-sql/commands/metadata/show-catalogs)
* [SHOW COLUMNS](/reference-sql/commands/metadata/show-columns)
* [SHOW ENGINES](/reference-sql/commands/metadata/show-engines)
* [SHOW INDEXES](/reference-sql/commands/metadata/show-indexes)
* [SHOW TABLES](/reference-sql/commands/metadata/show-tables)
* [SHOW VIEWS](/reference-sql/commands/metadata/show-views)

## Access control

* [ALTER LOGIN](/reference-sql/commands/access-control/alter-login)
* [ALTER NETWORK POLICY](/reference-sql/commands/access-control/alter-network-policy)
* [ALTER SERVICE ACCOUNT](/reference-sql/commands/access-control/alter-service-account)
* [ALTER USER](/reference-sql/commands/access-control/alter-user)
* [CREATE LOGIN](/reference-sql/commands/access-control/create-login)
* [CREATE NETWORK POLICY](/reference-sql/commands/access-control/create-network-policy)
* [CREATE ROLE](/reference-sql/commands/access-control/create-role)
* [CREATE SERVICE ACCOUNT](/reference-sql/commands/access-control/create-service-account)
* [CREATE USER](/reference-sql/commands/access-control/create-user)
* [DROP LOGIN](/reference-sql/commands/access-control/drop-login)
* [DROP NETWORK POLICY](/reference-sql/commands/access-control/drop-network-policy)
* [DROP ROLE](/reference-sql/commands/access-control/drop-role)
* [DROP SERVICE ACCOUNT](/reference-sql/commands/access-control/drop-service-account)
* [DROP USER](/reference-sql/commands/access-control/drop-user)
* [GRANT](/reference-sql/commands/access-control/grant)
* [REVOKE](/reference-sql/commands/access-control/revoke)