# Data Definition Language (DDL)

```{toctree}
:maxdepth: 1
:titlesonly:

CREATE DATABASE <create-database>
CREATE INDEX <create-index>
CREATE INDEX...USING IVFFLAT <create-index-ivfflat>
CREATE TABLE <create-table>
CREATE TABLE AS SELECT <create-table-as-select>
CREATE EXTERNAL TABLE <create-external-table>
CREATE PITR <create-pitr>
CREATE PUBLICATION <create-publication>
CREATE SEQUENCE <create-sequence>
CREATE STAGE <create-stage>
CREATE...FROM...PUBLICATION... <create-subscription>
CREATE VIEW <create-view>
CREATE FUNCTION...LANGUAGE SQL AS <create-function-sql>
CREATE SOURCE <create-source>
CREATE DYNAMIC TABLE <create-dynamic-table>
CREATE SNAPSHOT <create-snapshot>
ALTER TABLE <alter-table>
ALTER TABLE ... ALTER REINDEX <alter-reindex>
ALTER PITR <alter-pitr>
ALTER PUBLICATION <alter-publication>
ALTER SEQUENCE <alter-sequence>
ALTER STAGE <alter-stage>
ALTER VIEW <alter-view>
DROP DATABASE <drop-database>
DROP INDEX <drop-index>
DROP TABLE <drop-table>
DROP PITR <drop-pitr>
DROP PUBLICATION <drop-publication>
DROP SEQUENCE <drop-sequence>
DROP STAGE <drop-stage>
DROP SNAPSHOT <drop-snapshot>
DROP VIEW <drop-view>
DROP FUNCTION <drop-function>
TRUNCATE TABLE <truncate-table>
RENAME TABLE <rename-table>
RESTORE PITR <restore-pitr>
RESTORE ACCOUNT <restore-account>
RESTORE SNAPSHOT <restore-snapshot>
```