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

# Data Definition (DDL)

<a id="sql-ddl" />

Data Definition Language (DDL) statements define and manage the objects in a
*Kinetica* database. Use them to create, alter, and drop **schemas**, **tables**
(including external tables), **views** and **materialized views**,
**credentials**, **data sources**, **data sinks**, and **streams**.

The SQL commands below are grouped by the object they act on. See **Columns**
for the column types and properties used when defining a table's columns.

<CardGroup cols={2}>
  <Card title="Columns">
    * [Column Concepts](/content/sql/ddl/column-concepts)
    * [Column Types](/content/sql/ddl/column-types)
    * [Column Properties](/content/sql/ddl/column-properties)
  </Card>
</CardGroup>

## SQL Commands

<CardGroup cols={2}>
  <Card title="Schema">
    * [CREATE SCHEMA](/content/sql/ddl/create-schema)
    * [ALTER SCHEMA](/content/sql/ddl/alter-schema)
    * [DROP SCHEMA](/content/sql/ddl/drop-schema)
    * [SHOW SCHEMA](/content/sql/ddl/show-schema)
    * [DESCRIBE SCHEMA](/content/sql/ddl/describe-schema)
    * [SET CURRENT SCHEMA](/content/sql/ddl/set-current-schema)
  </Card>

  <Card title="Table">
    * [CREATE TABLE](/content/sql/ddl/create-table)
    * [CREATE EXTERNAL TABLE](/content/sql/ddl/create-external-table)
    * [CREATE TABLE ... AS](/content/sql/ddl/create-table-as)
    * [ALTER TABLE](/content/sql/ddl/alter-table)
    * [REFRESH EXTERNAL TABLE](/content/sql/ddl/refresh-external-table)
    * [REPAIR TABLE](/content/sql/ddl/repair-table)
    * [TRUNCATE TABLE](/content/sql/ddl/truncate-table)
    * [DROP TABLE](/content/sql/ddl/drop-table)
    * [SHOW TABLE](/content/sql/ddl/show-table)
    * [DESCRIBE TABLE](/content/sql/ddl/describe-table)
  </Card>

  <Card title="View">
    * [CREATE VIEW](/content/sql/ddl/create-view)
    * [CREATE MATERIALIZED VIEW](/content/sql/ddl/create-materialized-view)
    * [ALTER VIEW](/content/sql/ddl/alter-view)
    * [ALTER MATERIALIZED VIEW](/content/sql/ddl/alter-materialized-view)
    * [REFRESH VIEW](/content/sql/ddl/refresh-view)
    * [DROP VIEW](/content/sql/ddl/drop-view)
    * [SHOW VIEW](/content/sql/ddl/show-view)
    * [DESCRIBE VIEW](/content/sql/ddl/describe-view)
  </Card>

  <Card title="Credential">
    * [CREATE CREDENTIAL](/content/sql/ddl/create-credential)
    * [ALTER CREDENTIAL](/content/sql/ddl/alter-credential)
    * [DROP CREDENTIAL](/content/sql/ddl/drop-credential)
    * [SHOW CREDENTIAL](/content/sql/ddl/show-credential)
    * [DESCRIBE CREDENTIAL](/content/sql/ddl/describe-credential)
  </Card>

  <Card title="Data Source">
    * [CREATE DATA SOURCE](/content/sql/ddl/create-data-source)
    * [ALTER DATA SOURCE](/content/sql/ddl/alter-data-source)
    * [LIST DATA SOURCE](/content/sql/ddl/list-data-source)
    * [DROP DATA SOURCE](/content/sql/ddl/drop-data-source)
    * [SHOW DATA SOURCE](/content/sql/ddl/show-data-source)
    * [DESCRIBE DATA SOURCE](/content/sql/ddl/describe-data-source)
  </Card>

  <Card title="Data Sink">
    * [CREATE DATA SINK](/content/sql/ddl/create-data-sink)
    * [ALTER DATA SINK](/content/sql/ddl/alter-data-sink)
    * [DROP DATA SINK](/content/sql/ddl/drop-data-sink)
    * [SHOW DATA SINK](/content/sql/ddl/show-data-sink)
    * [DESCRIBE DATA SINK](/content/sql/ddl/describe-data-sink)
  </Card>

  <Card title="Data Lake Catalog">
    * [CREATE CATALOG](/content/sql/ddl/create-catalog)
    * [DROP CATALOG](/content/sql/ddl/drop-catalog)
    * [SHOW CATALOG](/content/sql/ddl/show-catalog)
    * [DESCRIBE CATALOG](/content/sql/ddl/describe-catalog)
  </Card>

  <Card title="Stream">
    * [CREATE STREAM](/content/sql/ddl/create-stream)
    * [DROP STREAM](/content/sql/ddl/drop-stream)
    * [SHOW STREAM](/content/sql/ddl/show-stream)
    * [DESCRIBE STREAM](/content/sql/ddl/describe-stream)
  </Card>

  <Card title="Other">
    * [DESCRIBE](/content/sql/ddl/describe)
    * [Comments](/content/sql/ddl/comments)
  </Card>
</CardGroup>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.