Teradata support summary

This article summarizes the features, objects, properties, and data types that are available for Teradata projects.

• Database (equivalent to schema in the traditional context)

• Tables

  • Database

  • Constraints

    • PK

    • FK

    • AK (UNIQUE)

  • INDEX

    • Columns

    • Order by

    • Description

  • Partitioning Key

    • Expression

    • Description

  • Check Constraints

    • Expression

    • Description

  • Options

    • Table type (set / multiset)

    • Table Kind (regular / global temp / volatile)

    • Fallback

    • Journal table

    • Log

    • Before journal

    • After journal

    • Checksum (dflt, on, off)

    • Freespace

    • Freespace as percent

    • Mergeblock ratio

    • Datablock size

    • Block compression

    • Map

    • Isolated loading

    • No primary index

  • Comment/Description

• Columns

  • Data type 

  • (NOT) NULL

  • Format

  • Title

  • Default

  • Character set (latin, unicode, graphic, kanji)

    • Case specific

    • Uppercase

    • With default

  • Compress values

  • Compress using

  • Decompress using

  • Identity 

    • Generated always/default

    • Start

    • Increment

    • Min

    • No min value

    • Max

    • No max value

    • Cycle

  • Description

• Views
  • Columns
  • Description
• Functions/UDFs
  • Overloading parameters
• Procedures
  • Overloading parameters