Tengri Data Platform Tengri Docs
Architecture Advantages Expert materials Contacts
    • Tengri Documentation
    • Architecture
      • Ideology of use
      • Separation of Compute and Storage
      • Storage
      • Calculation
      • PostgreSQL dialect and protocols
      • Developed system of differentiation of rights
    • Test results
      • TPC-H, Comparison with Greenplum
      • TPC-DS
    • Manual
      • Computing pools
      • User and rights management
        • Operations with users
        • Operations with roles
        • Operations with privileges
      • Data Description (DDL)
        • Operations with tables
        • Operations with schemes
        • Operations with views
      • Data query syntax
        • SELECT
        • WITH
        • FROM
        • JOIN
        • UNION
        • WHERE
        • CASE
        • GROUP BY
        • HAVING
        • QUALIFY
        • ORDER BY
        • LIMIT
        • OFFSET
        • BETWEEN
        • LIKE
        • ILIKE
        • SIMILAR TO
        • AS
        • DELETE
        • UPDATE
        • Functions
          • Aggregate functions
          • Numerical functions
          • Text functions
          • Functions for regular expressions
          • Functions for date and time
          • Functions for JSON
          • Functions for binary data
          • Functions for geodata
          • Window functions
          • Utilities
          • Python module tngri functions
        • Tengri’s own syntax
          • Keyword cell_output
          • Cross-language variables
      • Data types
        • Numeric types
        • Text type
        • Types for date and time
        • JSON type
        • Types for arrays
        • Binary type
        • Logical type
        • Type for geodata
    • Administrator’s Manual
    • AI agents
    • Scenarios
      • Initial system setup
      • Data loading
      • Automating data loading from multiple files
      • Accessing Iceberg storage directly using Python
      • Analytical scenarios
        • Analysing data from Instagram* posts
        • Analysing geodata from sports trackers
        • Analysing texts on the example of FineWeb dataset
        • Analysis and visualisation of passenger flow of Moscow metro stations
    • Alphabetical Index
  • Tengri Documentation
  • Manual
  • Data Description (DDL)
Download to PDF
EN
RU

Data Description (DDL)

The DDL commands are used to describe data — to create, manipulate, and delete tables, schemas, and views.

  • Operations with tables

  • Operations with schemes

  • Operations with views

Operations with privileges Operations with tables
Postgres Pro
VK
Youtube

© Postgres Pro
Legal Information
Tengri Data Platform is included in the Russian software registry.
Entry No. 31091 was made in the register on the basis of an order from the Ministry of Digital Development, Communications and Mass Media of the Russian Federation dated December 10, 2025.