Vertica-OT-White
  • Vertica Documentation
    • Supported platforms
    • New features
    • Getting started
    • Architecture
    • Setup
    • Eon
    • Containerized Vertica
    • Data exploration
    • Data load
    • Data analysis
    • Flex tables
    • Data export and replication
    • Management Console
    • Administrator's guide
    • Security & authentication
    • Connecting to Vertica
    • Extending Vertica
    • Hadoop integration
    • Kafka integration
    • Spark integration
    • Voltage SecureData integration
    • SQL reference
      • System limits
      • Language elements
      • Data types
      • Config parameters
      • File systems & object stores
      • Functions
      • Statements
        • ACTIVATE DIRECTED QUERY
        • ALTER statements
        • BEGIN
        • CALL
        • COMMENT ON statements
        • COMMIT
        • CONNECT TO VERTICA
        • COPY
        • COPY FROM VERTICA
        • COPY LOCAL
        • CREATE statements
          • CREATE ACCESS POLICY
          • CREATE AUTHENTICATION
          • CREATE CA BUNDLE
          • CREATE CERTIFICATE
          • CREATE DATA LOADER
          • CREATE DIRECTED QUERY
          • CREATE EXTERNAL TABLE AS COPY
          • CREATE EXTERNAL TABLE ICEBERG
          • CREATE FAULT GROUP
          • CREATE FLEXIBLE EXTERNAL TABLE AS COPY
          • CREATE FLEXIBLE TABLE
          • CREATE FUNCTION statements
            • CREATE AGGREGATE FUNCTION
            • CREATE ANALYTIC FUNCTION
            • CREATE FILTER
            • CREATE FUNCTION (scalar)
            • CREATE FUNCTION (SQL)
            • CREATE PARSER
            • CREATE SOURCE
            • CREATE TRANSFORM FUNCTION
          • CREATE HCATALOG SCHEMA
          • CREATE KEY
          • CREATE LIBRARY
          • CREATE LOAD BALANCE GROUP
          • CREATE LOCAL TEMPORARY VIEW
          • CREATE LOCATION
          • CREATE NETWORK ADDRESS
          • CREATE NETWORK INTERFACE
          • CREATE NOTIFIER
          • CREATE PROCEDURE (external)
          • CREATE PROCEDURE (stored)
          • CREATE PROFILE
          • CREATE PROJECTION
            • Encoding types
            • GROUPED clause
            • Hash segmentation clause
            • Live aggregate projection
            • Standard projection
            • Top-k projection
            • UDTF projection
            • Unsegmented clause
          • CREATE RESOURCE POOL
            • Built-in pools
            • Built-in resource pools config
          • CREATE ROLE
          • CREATE ROUTING RULE
          • CREATE SCHEDULE
          • CREATE SCHEMA
          • CREATE SEQUENCE
          • CREATE SUBNET
          • CREATE TABLE
            • Column-constraint
            • Column-definition
            • Column-name-list
            • Partition clause
            • Table-constraint
          • CREATE TEMPORARY TABLE
          • CREATE TEXT INDEX
          • CREATE TLS CONFIGURATION
          • CREATE TRIGGER
          • CREATE USER
          • CREATE VIEW
        • DEACTIVATE DIRECTED QUERY
        • DELETE
        • DISCONNECT
        • DO
        • DROP statements
        • END
        • EXECUTE DATA LOADER
        • EXPLAIN
        • EXPORT TO DELIMITED
        • EXPORT TO JSON
        • EXPORT TO ORC
        • EXPORT TO PARQUET
        • EXPORT TO VERTICA
        • GET DIRECTED QUERY
        • GRANT statements
        • INSERT
        • LOCK TABLE
        • MERGE
        • PROFILE
        • RELEASE SAVEPOINT
        • REPLICATE
        • REVOKE statements
        • ROLLBACK
        • ROLLBACK TO SAVEPOINT
        • SAVE QUERY
        • SAVEPOINT
        • SELECT
        • SET statements
        • SHOW
        • SHOW CURRENT
        • SHOW DATABASE
        • SHOW NODE
        • SHOW SESSION
        • SHOW USER
        • START TRANSACTION
        • TRUNCATE TABLE
        • UPDATE
      • Vertica system tables
    • API reference
    • Vertica error messages
    • Glossary
    • Copyright notice

Thanks for your feedback!

Print entire section
  1. SQL reference
  2. Statements
  3. CREATE statements

CREATE statements

CREATE statements let you create new database objects such as tables and users.

CREATE statements let you create new database objects such as tables and users.

In this section

  • CREATE ACCESS POLICY
  • CREATE AUTHENTICATION
  • CREATE CA BUNDLE
  • CREATE CERTIFICATE
  • CREATE DATA LOADER
  • CREATE DIRECTED QUERY
  • CREATE EXTERNAL TABLE AS COPY
  • CREATE EXTERNAL TABLE ICEBERG
  • CREATE FAULT GROUP
  • CREATE FLEXIBLE EXTERNAL TABLE AS COPY
  • CREATE FLEXIBLE TABLE
  • CREATE FUNCTION statements
  • CREATE HCATALOG SCHEMA
  • CREATE KEY
  • CREATE LIBRARY
  • CREATE LOAD BALANCE GROUP
  • CREATE LOCAL TEMPORARY VIEW
  • CREATE LOCATION
  • CREATE NETWORK ADDRESS
  • CREATE NETWORK INTERFACE
  • CREATE NOTIFIER
  • CREATE PROCEDURE (external)
  • CREATE PROCEDURE (stored)
  • CREATE PROFILE
  • CREATE PROJECTION
  • CREATE RESOURCE POOL
  • CREATE ROLE
  • CREATE ROUTING RULE
  • CREATE SCHEDULE
  • CREATE SCHEMA
  • CREATE SEQUENCE
  • CREATE SUBNET
  • CREATE TABLE
  • CREATE TEMPORARY TABLE
  • CREATE TEXT INDEX
  • CREATE TLS CONFIGURATION
  • CREATE TRIGGER
  • CREATE USER
  • CREATE VIEW
© 2024 Open Text Corporation All Rights Reserved
Privacy Policy
Cookie Preferences