Reference Guides

The Reference Guides section provides reference for using SQream DB’s interfaces and SQL features.

In this section:

• SQL Statements and Syntax
  • SQL Syntax Features
  • SQL Statements
    • Data Definition Commands (DDL)
    • Data Manipulation Commands (DML)
    • Utility Commands
    • Workload Management
    • Access Control Commands
  • SQL Functions
    • Summary of Functions
      • Built-In Scalar Functions
        • Bitwise Operations
        • Conditionals
        • Conversion
        • Date and Time
        • Numeric
        • Strings
      • User-Defined Scalar Functions
      • Aggregate Functions
      • Window Functions
      • Workload Management Functions
• Catalog Reference Guide
  • Overview
  • What Information Does the Schema Contain?
    • External Tables
    • Internal Tables
  • Catalog Tables
    • Clustering Keys
    • Columns
      • Columns
      • External Table Columns
    • Databases
    • Permissions
      • Permission Types
      • Default Permissions
        • Default Table Permissions
        • Default Schema Permissions
      • Table Permissions
      • Database Permissions
      • Schema Permissions
      • UDF Permissions
    • Queries
    • Roles
      • Roles
      • Role Memberships
    • Schemas
    • Sequences
      • Identity Key
    • Tables
      • Tables
      • Foreign Tables
    • Views
    • User Defined Functions
  • Additional Tables
    • Extents
    • Chunk Columns
    • Chunks
    • Delete Predicates
  • Examples
    • Listing All Tables in a Database
    • Listing All Schemas in a Database
    • Listing Columns and Their Types for a Specific Table
    • Listing Delete Predicates
    • Listing Saved Queries
• Command line programs
• SQL Feature Checklist
  • Data Types and Values
  • Constraints
  • Transactions
  • Indexes
  • Schema Changes
  • Statements
  • Clauses
  • Table Expressions
  • Scalar Expressions
  • Permissions
  • Extra Functionality