> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-structure.md).

# SQL Structure

{% columns %}
{% column %}
{% content-ref url="/pages/7O3ZItgujIK42hZyeUKO" %}
[SQL Language Structure](/docs/server/reference/sql-structure/sql-language-structure.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore the SQL language structure in MariaDB Server. This section provides fundamental concepts, syntax rules, and common elements that form the building blocks of SQL queries and commands.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/x8MYKERGJ9vEaS91TyoB" %}
[Joins, Subqueries, and Set](/docs/server/reference/sql-structure/joins-subqueries-set.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore joins, subqueries, and set operations in MariaDB SQL. This section details how to combine data from multiple tables, nest queries, and perform set-based operations for complex data retrieval.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/4TOczPcGOlNKDKB5ySp9" %}
[Geometry](/docs/server/reference/sql-structure/geometry.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore geometric data types and functions in MariaDB Server. This section details how to store, query, and manipulate spatial data, enabling geospatial applications within your database.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/OwqF7LnhjvogtK15gwAA" %}
[NoSQL](/docs/server/reference/sql-structure/nosql.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore MariaDB Server's NoSQL capabilities. This section details how to store and query schemaless data, including JSON, and how to integrate with other NoSQL data sources, enhancing flexibility.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/8dUkRUbx7ftObAITEzB3" %}
[Operators](/docs/server/reference/sql-structure/operators.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about operators in MariaDB Server SQL. This section details arithmetic, comparison, logical, and bitwise operators used in expressions and conditions for data manipulation and querying.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/CfT5PQXEtnXJ59MLVfrC" %}
[Sequences](/docs/server/reference/sql-structure/sequences.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Learn about sequences in MariaDB Server. This section details how to create and manage sequences for generating unique numbers, often used for primary keys and other auto-incrementing values.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/TZwF8PKNgJ2Q65j8RuTc" %}
[Temporal Tables](/docs/server/reference/sql-structure/temporal-tables.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore temporal tables in MariaDB Server. This section details how to manage data with system-versioning and application-time periods, enabling historical data tracking and time-aware queries.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/qMqVKoO9TGUMch4jEVb0" %}
[Vectors](/docs/server/reference/sql-structure/vectors.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Explore vector data types. This section details how to store and manage numerical arrays, enabling efficient vector similarity search and machine learning applications within your database.
{% endcolumn %}
{% endcolumns %}