meta_Partitioning - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

meta_Partitioning

Returns the Partitioning definitions referenced by tables, join indexes, and indexes in the system. Corresponds to the relationships TableHasPartitioning, JoinIndexPartitioning, and IndexHasPartitioning.

 

Table 120: Columns and Data Types of the meta_Partitioning View 

Column

Data Type

SystemName

VARCHAR(256)

DatabaseName

VARCHAR(128)

PartitionedTVMName

VARCHAR(128)

PartitionedTVMType

VARCHAR(5)

PartitioningType

VARCHAR(8)

NumberOfLevels

SHORT

IsSynchronized

VARCHAR(11)

PartitioningLoid

INTEGER