Rules for Primary Indexes and Their Defaults for a Column-Partitioned Table - Advanced SQL Engine - Teradata Database
SQL Data Definition Language Detailed Topics
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™
Introduction to SQL Data Definition Language Detailed Topics
Changes and Additions
ALTER FUNCTION - ALTER PROCEDURE
ALTER FUNCTION (External Form)
When to Specify Unprotected Mode
Special Considerations for Java UDFs
UDF Servers
Recompiling and Redistributing an Existing Function
Restrictions on Altering Functions That Implement UDT Transform and Ordering Functionality
ALTER METHOD
When to Specify Unprotected Mode
Recompiling and Redistributing an Existing Method
Restrictions on Altering Methods That Implement UDT Transform and Ordering Functionality
ALTER PROCEDURE (External Form)
Invocation Restrictions
Function of ALTER PROCEDURE (External Form) Requests
When to Specify Unprotected Mode
Protected Mode External Procedure Servers
Special Considerations for Java External Procedures
AT TIME ZONE Option for External Procedures
Dictionary Updates and the COMPILE Option for Java Procedures
ALTER PROCEDURE (SQL Form)
Invocation Restrictions
Limitations
Attributes Changed by ALTER PROCEDURE (SQL Form)
Attributes Not Changed by ALTER PROCEDURE (SQL Form)
ALTER PROCEDURE (SQL Form) Rules
AT TIME ZONE Option for SQL Procedures
Locks and Concurrency
ALTER TABLE
ALTER TABLE (Basic Table Parameters)
ALTER TABLE and Table Version Numbers
Rules and Restrictions for the Number of Changes Made in One ALTER TABLE Statement
Rules and Restrictions for Modifying Nonpartitioned NoPI Tables
About Referential Integrity Error Tables for Column-Partitioned Tables
Rules and Restrictions for Modifying NUMBER Columns
Rules and Restrictions for Modifying Queue Tables
Rules and Restrictions for Modifying Data Tables Defined With an Error Table
Rules and Restrictions for Large Object Data Types
ALTER TABLE Support For UDTs
Recommended Null Handling Technique For UDT Columns
Dropping a Column and Statistics
Changing a Column Data Type and Statistics
ALTER TABLE and FALLBACK
ALTER TABLE, FALLBACK, and Read From Fallback
Transient Journaling
Activating Permanent Journaling
Local Journaling
FREESPACE PERCENT
MERGEBLOCKRATIO
MINIMUM DATABLOCKSIZE
IMMEDIATE DATABLOCKSIZE
BLOCKCOMPRESSION
Adding Columns To a Table
Adding Columns to a Column-Partitioned Table
Adding Columns to a Column Partition in a Column-Partitioned Table
Adding Columns to a Normalized Table
Maximum Number of Columns in Table
Changing Column Attributes: NOT NULL or NULL
Modifying Column Data Types or Multivalue Compression
Adding, Modifying, or Dropping Algorithmic Compression
Adding, Modifying, or Dropping Block-Level Compression
Data Type and Attribute Definitions
Changing a Data Type Attribute
Rules for Adding or Modifying Multivalue Compression for a Column
Adding and Dropping CHECK Constraints
Dropping Columns From a Table
Dropping Columns from a Column-Partitioned Table
Dropping Columns from a Normalized Table
Renaming Table Columns
Adding or Dropping PRIMARY KEY and UNIQUE Constraints
Adding or Dropping Standard Referential Integrity Constraints
Adding or Dropping Batch Referential Integrity Constraints
Adding or Dropping Referential Constraints
Maintaining Foreign Key Integrity
Referential Integrity When a Table Is Inconsistent
Rules for Changing Column Data Types
Procedure to Change Column Data Types
Effect of Changing Column Data Type on Statistics
ALTER TABLE (MODIFY Option)
Redefining the Primary, Primary AMP, or Partitioning for a Table
Redefining Primary Index, Primary AMP Index, or Partitioning without ALTER TABLE
Altering a Primary Index or Primary AMP Index Using ALTER TABLE
Dropping or Adding New Ranges or Partitions to a Row-Partitioned Table
General Rules for the MODIFY PRIMARY Clause
MODIFY PRIMARY Option
MODIFY NO PRIMARY Option
Rules for Modifying Populated and Unpopulated Tables and Join Indexes
Modifying the Partitioning of a Table or Join Index
WITH INSERT and WITH DELETE Null Partition Handling Clauses
RANGE_N and CASE_N Functions
Modifying Partitioning Using the ADD RANGE and DROP RANGE Options
Best Practices for Adding and Dropping Partitioning Ranges from a Partitioning Expression
COLUMN Option for Column Partitioning
Rules for the MODIFY For Multilevel Partitioning
Rules for the MODIFY Options for Character Partitioning
Rules For Altering a Partitioning For a Table
Modifying Row Partitioning Defined With an Updatable DATE, CURRENT_DATE, or CURRENT_TIMESTAMP
Rules for Adding and Dropping Ranges in a Character Partitioning Expression
Rules for Altering the Row Partitioning for Character Partitioning
Rules for Altering the Partitioning Expression for Multilevel Partitioning
Rules and Restrictions for Modifying Column-Partitioned Tables
Rules for Retaining Eligibility for Restoring or Copying Selected Partitions
ALTER TABLE (REVALIDATE Option)
General Rules and Restrictions for the REVALIDATE Option
Revalidating the Partitioning for Tables and Join Indexes With a HASH Function Partitioning Expression
ALTER TABLE (Set Down and Reset Down Options)
SET DOWN and RESET DOWN Options
SET DOWN
RESET DOWN
ALTER TABLE TO CURRENT
Comparing ALTER TABLE TO CURRENT and ALTER TABLE … REVALIDATE
General Usage Guidelines and Rules for ALTER TABLE TO CURRENT Requests
Guideline for Refreshing Partition Statistics After An ALTER TABLE TO CURRENT Request
Using ALTER TABLE TO CURRENT Requests to Reconcile Join Indexes
Related Information
ALTER TYPE
Adding Attributes To a Structured UDT
Workaround for Adding More Than 512 Attributes to a Structured UDT
Dropping Attributes From a Structured UDT
Adding Methods To a UDT
Dropping Methods From a UDT
Altering Attributes Of A Structured UDT Definition
Altering The Method Signatures Of A Structured UDT Definition
Recompiling a UDT
Related Information
BEGIN QUERY CAPTURE- COMMENT
BEGIN QUERY CAPTURE
Rules and Restrictions for BEGIN QUERY CAPTURE
BEGIN QUERY LOGGING
Uses for Database Query Logging
Logging Options for BEGIN QUERY LOGGING
Limit Options for BEGIN QUERY LOGGING
Flushing the Database Query Log
Flushing DBQL Rules From the Cache
Dealing With Session Account String Changes
Hierarchy of Applying Database Query Logging Rules
Application Names
Not All SQL Request Text Is Logged By The Query Logging Feature
Limits of Dynamically Enabled Query Logging
Query Logging and SQL Transactions
Minimum Level of Query Logging
Database Query Log Tables and Views
Query Logging User Rules
Using BEGIN QUERY LOGGING to Log Query Plan Information
Using SUMMARY Query Logging for Tactical Queries
Related Information
COLLECT STATISTICS (Optimizer Form)
Why You Need To Collect Statistics
Naming Collected Statistics
Keep Statistics Current
PARTITION Statistics and ALTER TABLE TO CURRENT Requests
Location of Stored Statistics
Collecting and Recollecting Statistics Is Often Time Consuming
Reducing the Cost of Collecting Statistics by Sampling
Comparison of Full and Sampled Statistics
Using the THRESHOLD Options to Collect and Recollect Statistics
USING Options
FOR CURRENT Option
Rules and Guidelines for COLLECT STATISTICS (Optimizer Form)
Rules and Guidelines for the COLLECT STATISTICS (Optimizer Form) FROM source_table Clause
Locks and Concurrency
Collecting Statistics When No COLUMN or INDEX Clause Is Specified
Collecting Statistics on Single-Column Indexes
Collecting Statistics on Multiple Columns
Collecting Statistics on the PARTITION Column and the Row Partitioning Column Set
Collecting Statistics for Star Joins
Collecting Statistics on NUSIs Defined Using ALL and ORDER BY
Collecting Statistics on Large Objects, UDTs, and Period Columns
Collecting Statistics on Derived Period Columns
Collecting Statistics on Hash and Join Indexes
Collecting Statistics on Unique Join Indexes
Collecting Statistics on a PERIOD Data Type Column
Collecting Statistics on a UDF
Using Named Indexes To Collect Statistics
Related Information
COMMENT (Comment Placing Form)
Typical Use for COMMENT
Rules for Using COMMENT
Japanese Characters in Comments
Related Information
CREATE AUTHORIZATION - CREATE ERROR TABLE
CREATE AUTHORIZATION and REPLACE AUTHORIZATION
Providing Security for User-Written External Routines
DEFINER and INVOKER Authorizations
Authorization Rules
Function of CREATE AUTHORIZATION Requests
CREATE CAST and REPLACE CAST
Difference Between CREATE CAST and REPLACE CAST
Function of Casting UDTs
Using the AS ASSIGNMENT Clause To Make a Cast Operation Implicitly Invokable
Creating Parallel Cast and Transform Functionality
Possible Predefined Type Source and Target User-Defined Cast Combinations
Cast Requirements for Teradata Utilities
CREATE DATABASE
Rules for Using CREATE DATABASE
PERMANENT, SPOOL, and TEMPORARY Space
Local Journaling
Activating Permanent Journaling
Related Information
CREATE ERROR TABLE
Rules and Restrictions for Error Tables
Error Logging Limits
Function of Error Tables
System-Defined Attributes for Error Table-Specific Columns
Error Table Row Size Minimization
Dictionary Support for Error Tables
Usage Considerations for the Error Table Columns
Using Error Table Data to Isolate Problems
Handling Logged Reference Index and Unique Secondary Index Errors
CREATE FUNCTION - CREATE GLOBAL TEMPORARY TRACE TABLE
CREATE FUNCTION and REPLACE FUNCTION (External Form)
UDF Parameter Styles
Downloadable UDF Samples
Relationship Among UDFs, Table UDFs, Methods, and External Procedures
Naming Conventions: Avoiding Name Clashes Among UDFs, UDMs, and UDTs
Usage Restrictions for User-Defined Functions
Restrictions On Replacing UDFs That Implement Operations On UDTs
Protected and Unprotected Execution Modes
UDF Handling of SQL Result Codes
Differences Between CREATE FUNCTION and REPLACE FUNCTION
CREATE FUNCTION and Multivalue Compression of UDT Columns
CREATE FUNCTION and Algorithmic Compression of UDT Columns
REPLACE FUNCTION and Algorithmic Compression
User-Defined Functions and Large Objects
Function Identifiers
Function Name
Function Calling Argument
Function Overloading
Parameter Names and Data Types
Row-Level Security UDF Enforcement of the Security Policy for a Row
General Rules for Creating a Row-Level Security UDF
General Rules for Row-Level Security Function Parameter Styles
Rules for INSERT and UPDATE Row-Level Security Policy Functions
Rules for SELECT and DELETE Row-Level Security Policy Functions
Writing a UDF That Uses VARIANT_TYPE UDT Parameters
Writing a UDF That Uses TD_ANYTYPE UDT Parameters
RETURNS Clause
Restrictions on Declaring an External C++ Function
SQL Data Access Clause
Optional Function Characteristics
SPECIFIC Function Name Clause
Function Class Clause
Optimizing the Aggregate Cache
Parameter Style Clause
Deterministic Characteristics Clause
Null Call Clause
External Data Access Clause
External Body Reference Clause
EXTERNAL NAME Clause
External String Literal
Function Entry Name Clause
Client-Server UDF Code Specification
Include Name Clause
Library Name Clause
Object File Name Clause
Package Name Clause
Source File Name Clause
External String Literal Examples
UDF Default Location Paths
UDF .so File Linkage Information
External Security Clause
Related Information
CREATE FUNCTION (Table Form)
Relationship Among UDFs, Table UDFs, and External Procedures.
Definition of a Table Function
Typical Uses for Table Functions
General Limitations and Restrictions on Table Functions
Protected and Unprotected Modes
Handling SQL Result Codes
Mandatory Function Attributes
Parameter Names and Data Types
Managing UDF Memory Allocation
Writing a UDF That Uses Dynamic UDT Parameters
RETURNS TABLE Clause
Optional Function Characteristics
Parameter Style Clause
Null Call Clause
External Body Reference Clause
Table UDF Default Location Paths
Table UDF .so Linkage Information
Restrictions on Calling Table Functions
Restrictions on Declaring an External C++ Table Function
Restriction on Using a Table Function to Enforce Row-Level Security
About Table Operator UDFs
Differences Between Table Operators and Table Functions
CREATE FUNCTION and REPLACE FUNCTION (SQL Form)
Relationship Among SQL UDFs, External UDFs, Table UDFs, Methods, and External Procedures
Naming Conventions: Avoiding Name Clashes Among UDFs, UDMs, and UDTs
Rules for Using SQL UDFs
Protected and Unprotected Execution Modes
How SQL UDFs Handle SQL Result Codes
Differences Between CREATE FUNCTION and REPLACE FUNCTION
SQL UDFs and Embedded SQL
SQL UDFs and SQL Cursors
Passing Parameters to an SQL UDF
SQL User-Defined Functions and Large Objects
Function Identifiers
Function Name
Function Calling Argument
Function Name Overloading
Parameter Names and Data Types
RETURNS Clause
SQL Data Access Clause
Optional Function Characteristics
SPECIFIC Function Name Clause
Deterministic Characteristics Clause
Null Call Clause
SQL SECURITY Clause
INLINE Clause
COLLATION Clause
RETURN Statement
Restriction on Using an SQL Function to Enforce Row-Level Security
Related Information
CREATE GLOBAL TEMPORARY TRACE TABLE
Function of Global Temporary Trace Tables
Rules and Limitations for Global Temporary Trace Tables
CREATE HASH INDEX - CREATE ORDERING
CREATE HASH INDEX
Use Single-Table Join Indexes Instead of Hash Indexes
Specifying the Primary Index for a Hash Index
Maximum Number of Hash, Join, and Secondary Indexes Definable Per Data or Join Index Table
Fallback and Hash Indexes
Comparison of Hash and Single-Table Join Indexes
Compressing Hash Index Column Values
Compression of Hash Index Rows
Collecting Statistics on a Hash Index
Collect Statistics on Base Table Columns Instead of Hash Index Columns
Guidelines for Collecting Statistics On Hash Index Columns
Hash Indexes Are Maintained by Vantage
Creating Hash Indexes for Tables With Row-Partitioned Primary Indexes
Restrictions and Limitations for NoPI and Column-Partitioned Tables
Restrictions and Limitations for Error Tables
Restrictions and Limitations for Load Utilities
Restrictions and Limitations for Ordered Analytical Functions
Restrictions and Limitations for Structured UDT Columns
Restrictions and Limitations for Large Objects
Restrictions and Limitations for Triggers
Considerations After a System Reconfiguration
Restrictions on Creating a Hash Index on a Table Concurrent With Dynamic AMP Sample Emulation on That Table
Permanent Journal Recovery of Hash Indexes Is Not Supported
Block-Level Compression and Hash Indexes
CREATE INDEX
Locks and Concurrency
Collecting Statistics on a Secondary Index
Maximum Number of Indexes
Fallback and Secondary Indexes
System-Defined Unique Secondary Indexes
Why Consecutive Indexes Are Important For Value-Ordered NUSIs
Storage and Performance Considerations for Secondary Indexes
Secondary Indexes Can Shorten Search Time
CREATE INDEX and the QITS Column of Queue Tables
UNIQUE Versus Nonunique Secondary Indexes
Use EXPLAIN to Analyze the Usefulness of Secondary Indexes
Named Indexes
Relationships Between Secondary Indexes and Primary Indexes or Primary AMP Indexes
Disk I/O Integrity Checking
Restrictions and Limitations for Error Tables
Restrictions and Limitations for Large Object, Period, and Geospatial Columns Used in a Secondary Index Definition
Restrictions and Limitations for Teradata Row-Level Security Columns Used in a Secondary Index Definition
Restrictions on Creating a Secondary Index on a Table Concurrent With Dynamic AMP Sample Emulation on That Table
Block Compression and Secondary Indexes
CREATE JOIN INDEX
Locks and Concurrency
Maximum Number of Indexes Definable Per Data, Hash, or Join Index Table
Fallback and Join Indexes
Defining a Unique Primary Index for a Join Index
Partitioned Tables and Join Indexes
Working Around Optimizer Memory Problems Encountered When Creating Join Indexes for Partitioned Tables
Distribution of Join Index Rows
Rules and Restrictions for Join Indexes
Guidelines for Row-Partitioned PI Join Indexes
Choosing Between a Row-Partitioned Join Index and a Value-Ordered NUSI For Covering Range Queries
Column-Partitioned Join Indexes
Rules and Restrictions for Column-Partitioned Join Indexes
BLOCKCOMPRESSION
Similarities and Differences Between Join Indexes and Base Tables
Join Index Updates Are Maintained by Vantage
Simple Join Indexes
Aggregate Join Indexes
Optimizer Rules for Using Aggregate Join Indexes in a Query Plan
Sparse Join Indexes
Join Indexes, Expressions, and Built-In Functions
Outer Joins and Simple Join Indexes
Collecting Statistics on Join Indexes
Collecting Statistics on a Single-Table Join Index
Collecting Statistics on Base Table Columns Instead of Single-Table Join Index Columns
Guidelines for Collecting Statistics On Single-Table Join Index Columns
Collecting Statistics on Multitable Join Indexes
Compression of Join Index Column Values
Row Compression of Join Indexes
Physical Join Index Row Compression
Guidelines for Using Row Compression With Join Index Columns
Query Coverage by Join Indexes
Restriction on Partial Coverage of Queries Containing a TOP n or TOP m PERCENT Clause
Restriction on Coverage by Join Indexes When a Join Index Definition References More Tables Than a Query
Rules for Whether Join Indexes With Extra Tables Cover Queries
Restriction on Number of Join Indexes Selected by the Optimizer Per Table
Restrictions and Limitations for Error Tables
Restrictions and Limitations for Row-Level Security Columns
Restrictions and Limitations for SQL UDFs
Restrictions and Limitations for the EXPAND ON Clause
Restrictions and Limitations for Ordered Analytical Functions
Restrictions and Limitations for Join Index Normalization
Restrictions and Limitations for Load Utilities
Restrictions and Limitations for the Reconfig Utility
Restrictions on Creating a Join Index on a Table Concurrent With Dynamic AMP Sample Emulation on That Table
Permanent Journal Recovery of Join Indexes Is Not Supported
Block-Level Compression and Join Indexes
CREATE MACRO and REPLACE MACRO
Restriction on External Authorization From a Macro
Running a Macro
Limit On Request Size
Resolution of Non-Qualified Names
Semantic Errors Are Sometimes Not Reported At the Time a Macro Is Created
Using the ASTERISK (*) Character in Macros
Rules for Using Parameters in Macros
Macro Definitions and Server Character Sets
Macro Support for Dates
Macro Support for Global Temporary and Volatile Tables
Macro Support for Large Objects
Macro Support for UDFs
Macro Support for UDTs
Macro Support for Query Bands
Macro Support for Query Bands in Proxy Connections
Macro Support for Workload Analysis Statements
Macros and Tactical Queries
Function of REPLACE MACRO Requests
CREATE METHOD
Method Definitions Are Split Between CREATE METHOD And CREATE TYPE Definitions
Dropping A Method
Character Set Issues for Naming Methods
Naming Conventions: Avoiding Name Clashes Among UDFs, UDMs, and UDTs
Definitions And Purposes Of The Various Method Names
Function of Methods
Method Types
Instance Methods
Constructor Methods
Method Signatures
Relationship Among Methods, UDFs, and External Procedures
When To Run Methods in Unprotected Mode
External Security Clause
CREATE ORDERING and REPLACE ORDERING
How REPLACE ORDERING Differs From CREATE ORDERING
System Default Ordering Functionality for ARRAY and VARRAY Types
Function of UDT Ordering Maps
Why Vantage Does Not Support The ANSI SQL STATE and RELATIVE Comparison Options
Rules for Order Mapping UDFs
Rules for Order Mapping Methods
Recommendation for Handling Nulls
High-Level Description of How MAP Routines Work
Relationship Between Ordering And Collation Sequence For Character Data
CREATE ORDERING/REPLACE ORDERING and System-Generated Constructor UDFs
CREATE PROCEDURE and REPLACE PROCEDURE (External Form)
Relationship Among UDFs, Table UDFs, and External Procedures
Usage Restrictions for External Procedures
Memory Considerations for INOUT Parameters
Recompiling an External Procedure
When To Run External Procedures in Unprotected Mode
Differences Between CREATE PROCEDURE and REPLACE PROCEDURE
Dynamic Result Sets
External Procedures and Large Objects
Teradata Unity Support for External Procedures
Parameter Names and Data Types
LANGUAGE Clause
SQL DATA ACCESS Options
External Data Access Clause
SQL SECURITY Privilege Options
External SQL Procedures and SQL
Restrictions on Declaring an C++ External Procedure
Rules for Creating a Java External Procedure
Details About the Function of Java External Procedures
JAR Files
Data Type Mapping Between SQL and Java
SQLSTATE Values for Java External Procedures
Java External Routine-Specific Dictionary Tables
SQLJ Database
CREATE PROCEDURE Dictionary Table Actions for Java Procedures
REPLACE PROCEDURE Dictionary Table Actions for Java Procedures
SQL DATA ACCESS Clause
PARAMETER STYLE Clause
External Body Reference Clause
EXTERNAL NAME Clause
External String Literal
External Java Reference Strings
Client-Server External Procedure Code Specification
Include Name Clause
Library Name Clause
Object File Name Clause
Package Name Clause
Specifying the CLI Option for the EXTERNAL NAME Package Clause
Source File Name Clause
External String Literal Examples
External Procedure Default Location Paths
External Procedure and UDF .so Linkage Information
EXTERNAL SECURITY Clause
Related Information
CREATE PROCEDURE and REPLACE PROCEDURE (SQL Form)
SQL Data Access Options
SQL SECURITY Privilege Options
Invocation Restrictions
Default Session Collation For Procedures
Memory Considerations for INOUT Parameters
Recompiling an SQL Procedure
Special Condition Handling for SIGNAL and RESIGNAL Statements
Details About Dynamic Result Sets
Rules and Limitations for Dynamic Result Sets
Teradata Unity Support for SQL Procedures
SQL Procedure Support for Transaction Query Bands
SQL Procedures and Proxy Connections
SQL Procedure Support For UDTs
Supported DDL Statements in SQL Procedures
Usage Considerations for DDL Statements in Procedures
Unsupported DDL Statements in SQL Procedures
Session Mode Impact on DDL Requests in Procedures
Supported DML Statements in SQL Procedures
Unsupported DML Statements in SQL Procedures
Supported DCL Statements in SQL Procedures
Unsupported DCL Statements in SQL Procedures
Session Mode Impact on DCL Statements in SQL Procedures
Rules for Using the PREPARE Statement In an SQL Procedure
Guidelines for Using the CURRENT_TIME and CURRENT_TIMESTAMP Functions in an SQL Procedure
SQL Multistatement Request Support in SQL Procedures
Utilities and APIs Supporting CREATE/REPLACE PROCEDURE
SQL Procedure Options
Guidelines for Manipulating LOBs in an SQL Procedure
Procedure for Creating an SQL Procedure
Completing the Creation of an SQL Procedure
Aborting the Creation of an SQL Procedure
Processing an SQL CREATE PROCEDURE Request
Retrieving an SQL Procedure Body
Function of REPLACE PROCEDURE Requests
Significance of Platform and Session Mode For REPLACE PROCEDURE
CREATE RECURSIVE VIEW and REPLACE RECURSIVE VIEW
Updatability of Recursive Views
The Concept of Recursion
Controlling the Cardinality Estimate For the Final Recursive Result Spool
All Recursive View Definitions Must Be Linear
Building a Recursive View
Stratification of Recursive View Evaluation
Specifying RECURSIVE For a Non-Recursive View
Seed Statement Component of the View Definition
Recursive Statement Component of the View Definition
You Can Specify Multiple Seed and Recursive Statements Within a Single Recursive View Definition
Recursive View Definition Restrictions
Referential Restrictions For Recursive Views
Step Building Logic for Recursive Queries
Preventing Infinite Recursion Due To Cyclic Data
Preventing Infinite Recursion With Acyclic Data
Breadth First and Depth First Searches
Breadth First Reporting
Depth First Reporting
Related Information
CREATE TABLE Options
CREATE TABLE
Block-Level Compression and Tables
Table Restrictions On Using UDT Columns
CREATE TABLE (Table Kind Clause)
Global Temporary Tables
Volatile Tables
Volatile and Global Temporary Tables, Teradata Session Mode, and DML Performance
Resolving Table References
Table Kinds and UDT, Period, and Geospatial Data Types
Related Information
CREATE TABLE (Table Options Clause)
Table Options and the ANSI SQL:2011 Standard
Specifying Data Protection
Specifying FALLBACK
Transient Journaling
LOG and NO LOG
Permanent Journaling
Assigning a Permanent Journal to a Table
Providing for a Permanent Journal
FREESPACE PERCENT
MERGEBLOCKRATIO
DATABLOCKSIZE
BLOCKCOMPRESSION
Performance Aspects of Merging Data Blocks
Table Options and UDT, ARRAY, VARRAY, Geospatial, and Period Data Types
CREATE TABLE (Column Definition Clause)
About Table Column Elements
Data Type, Column Storage, and Constraint Attributes
Null Handling for UDT, ARRAY, VARRAY, Geospatial, and Period Columns
Prerequisites for Specifying a UDT, ARRAY, VARRAY, Period, or Geospatial Column in a Table Definition
Table Size and Maximum Number of Columns Per Table
Identity Columns
Process for Generating Identity Column Numbers
Rules for Specifying Identity Columns
Identity Columns, Duplicate Column Values, and Duplicate Rows
Identity Columns and Bulk Inserts
Optimizing Bulk Inserts Into an Identity Column
Identity Column Inserts and Transaction-Bound Table Locks on DBC.IdCol
Comparing the Characteristics of the Various Compression Methods Available to Vantage
Compressing Column Values Using Only Multivalue Compression
Compressing Column Values Using Only Algorithmic Compression
Common Rules for Multivalue and Algorithmic Compression
Other Forms of Compression Used by Vantage
Combining Multivalue, Algorithmic, and Block-Level Compression
Integrity Constraint Levels
PRIMARY KEY Constraints
Surrogate Keys
UNIQUE Constraints
PRIMARY KEY Constraints Versus UNIQUE Constraints
CHECK Constraints
FOREIGN KEY Constraints
Referential Integrity Constraints
Standard Referential Integrity Constraints
Batch Referential Integrity Constraints
Referential Constraints
Comparison of Referential Integrity Constraint Types
An Example of How the Optimizer Takes Advantage of Referential Constraints
Rules for Using Referential Constraints
Validating the Integrity of Base Tables In a Referential Constraint Relationship
Scenario for Data Corruption With Referential Constraints
Normalizing Database Tables
Rules and Restrictions for the NORMALIZE Option
Related Information
CREATE TABLE Indexes
CREATE TABLE (Index Definition Clause)
About Primary-Indexing, Row-Partitioning, Column-Partitioning, NoPI Tables, and Secondary Indexes
Index Types
Primary Indexes
Nonpartitioned NoPI Tables
Column-Partitioned Tables
Usage Guidelines for Column-Partitioned Tables
Rules and Restrictions for Column-Partitioned Tables
General Rules for Column-Partitioned Tables
Rules for Column Partitions in a Column-Partitioned Table
Rules for Partition Formats in a Column-Partitioned Table
Rules for Primary Indexes and Their Defaults for a Column-Partitioned Table
Rules for Specifying Column Grouping in a Column-Partitioned Table
Rules for Using the ADD Option for the Partitioning Levels of a Column-Partitioned Table
Rules for the Maximum Partition Numbers and Partitioning Levels of a Column-Partitioned Table
Rules for Using Client Load Utilities With A Column-Partitioned Table
Performance Issues for Column-Partitioned Tables
Comparing Nonpartitioned NoPI Tables With Column-Partitioned Tables With and Without Autocompression
Partitioned and Nonpartitioned Primary Indexes
ADD Option
Partitioning Expressions Using on a CASE_N or RANGE_N Character Column
Partitioning Expressions Using DATE or TIMESTAMP Built-In Functions
Partitioning Expression Based on Updatable Current Date and Timestamp Expressions
Optimal Reconciliation of CASE_N Partitioning Expressions Based on Updatable Current Date and Timestamp
Optimal Reconciliation of RANGE_N PPI Expressions Based on Updatable Current Date and Timestamp
Optimal Reconciliation of CASE Partitioning Expressions Based On Updatable Current Date and Timestamp
Optimal Reconciliation of Partitioning Expressions Based On Updatable Current Date and Timestamp
Partitioning Expression Columns and the Primary Index
Query Conditions and Static Row Partition Elimination
Join Conditions and Partitioned Primary Indexes
Effects of Dynamic Row Partition Elimination on Joins
Rules and Usage Notes for Partitioned Tables
Partitioning CHECK Constraints for Partitioned Tables With 2-Byte Partitioning
Partitioning CHECK Constraint for Partitioned Tables with 8-Byte Partitioning
Restrictions for Multilevel Partitioning
Combined Partitioning Expressions
Rules and Usage Notes for Multilevel Partitioning
Purpose and Behavior of the NO RANGE and UNKNOWN Partitions
Determining the Partitioning Granularity
Memory Limitations Related to Partitioned Tables
Restrictions and Limitations for Load Utilities and Partitioned Tables
Restrictions and Limitations for Archive/Recovery and Partitioned Tables
Secondary Indexes
PRIMARY KEY and UNIQUE Constraints Versus Primary Indexes
Nullable Columns Are Valid for Unique Indexes
Related Information
CREATE TABLE Global and Temporary
CREATE TABLE (Global Temporary/Volatile Table Preservation Clause)
About Deleting or Preserving Global Temporary and Volatile Table Contents
ON COMMIT DELETE/PRESERVE ROWS
Related Information
CREATE TABLE AS
CREATE TABLE (AS Clause)
Required Privileges
About Copying Table Definitions
Copying Table Definitions
Target Table Kind Defaults
Exclusions from CREATE TABLE … AS Syntax
General Usage Rules
Usage Rules for Normalized Tables
Attributes Not Copied To The Target Table
Using Subqueries To Customize An AS Clause
Exclusive AS … WITH DATA Clause Rules
Comparing PARTITION Statistics Copied With COLLECT STATISTICS … FROM source_table to PARTITION Statistics Copied With CREATE TABLE AS … WITH DATA AND STATISTICS
General Rules For CREATE TABLE AS … WITH DATA AND STATISTICS
Specific Rules For CREATE TABLE AS … WITH DATA AND STATISTICS That Does Not Use a Subquery To Define The Source Table Column And Index Set
Specific Rules For AS … WITH DATA AND STATISTICS That Uses A Subquery To Define The Source Table Column And Index Set
General Rules For CREATE TABLE AS … WITH NO DATA
Rules For CREATE TABLE AS … WITH NO DATA That Does Not Use a Subquery To Define The Source
Rules For AS … WITH NO DATA That Uses A Subquery To Define The Source
Misleading Similarities of WITH DATA and WITH NO DATA Clauses
Related Information
CREATE TABLE Queue
CREATE TABLE (Queue Table Form)
Information About Table Characteristics Not Specific To Queue Tables
QUEUE Keyword
QITS Column
Function of Queue Tables
Queue Table Cache
Identifying Queue Tables
SQL Operations on Queue Tables
Consume Mode Transactions
Performance Issues for Queue Tables
Restrictions on Queue Tables
Queue Table-Related Restrictions on Other SQL Statements
Browsing a Queue Table
Rules for Consuming Rows From a Queue
Restrictions on Consume Mode SELECT Statements
Ordering Queue Table Rows
Populating a Queue Table
Considerations for Populating an Unpopulated Queue Table in a Delayed State
Using Multistatement Requests To Populate Queue Tables
Related Information
CREATE TRANSFORM - CREATE VIEW
CREATE TRANSFORM and REPLACE TRANSFORM
How REPLACE TRANSFORM Differs From CREATE TRANSFORM
Function of UDT Transforms
Creating Parallel Cast and Transform Functionality
Rules For tosql Transform Routines
Valid tosql Transform Functionality
Rules For fromsql Transform Routines
Valid fromsql Transform Functionality
Transform Requirements for Teradata Utilities
Miscellaneous UDT Information Related To Client Applications and Transforms
CREATE TRANSFORM/REPLACE TRANSFORM And System-Generated Constructor UDFs
CREATE TRIGGER/
REPLACE TRIGGER
Teradata Extensions to ANSI Triggers
Function of REPLACE TRIGGER Requests
Trigger Terminology
Transition Tables
REFERENCING Clause
Rules For Using the REFERENCING Clause
Row and Statement Triggers
Triggered Action Statements
Triggers and Referential Integrity
Triggers and Stored Procedures
Triggers and External Stored Procedures That Make SQL Calls
Triggers and MERGE Requests
Triggers and Query Bands
Trigger Support for Teradata Unity
Database Objects That Cannot Be Referenced In A Trigger Definition
SET as a Triggered Action Statement
Cascading and Recursion of Triggers
Restrictions on Creating and Using Triggers
Triggers and Identity Columns
Unsupported Trigger Features
Restrictions and Limitations for NoPI Tables
Restrictions and Limitations for Normalized Table Columns
Restrictions and Limitations for Load Utilities
Dropping or Deleting Database Objects That Contain Triggers
Triggers, Partitioned Primary Indexes, and the ALTER TABLE Statement
Performance Issues for Triggers
Guidelines for Creating Triggers
Rules for Using Scalar Subqueries in Triggers
When To Use Row Triggers
Advantages of Row Triggers
When to Use Statement Triggers
Triggers and Tactical Queries
CREATE TYPE (ARRAY/VARRAY Form)
Supported ARRAY and VARRAY Data Type Elements
Rules and Restrictions for One-Dimensional ARRAY and VARRAY Data Types
System-Generated Default Functionalities For One Dimensional ARRAY and VARRAY UDTs
Rules and Restrictions for Multidimensional ARRAY and VARRAY Data Types
System-Generated Default Functionalities for Multidimensional ARRAY and VARRAY UDTs
Unexpected Row Length Errors for UTF-8 Session Character Set Data
Transform Input/Output Strings for ARRAY/VARRAY Types
ARRAY and VARRAY Columns in SELECT Requests
ARRAY and VARRAY Columns in an Index Definition
Related Information
CREATE TYPE (Distinct Form)
Internal And External Representations Of Distinct UDTs
Similarities With The Syntax For CREATE TYPE (Structured Form)
Character Set Issues for Naming Distinct UDTs
Naming Conventions: Avoiding Name Clashes Among UDFs, UDMs, and UDTs
Function of Distinct UDTs
System-Generated Default Functionalities For Distinct UDTs
Casting Character String Attributes
Enabling Full Functionality For a Distinct UDT
SYSUDTLIB Database
External Routines
Tasks You Must Perform To Create A Distinct UDT
Method Signatures
Effect of Platform on Storage Size of Distinct UDTs
Period and Geospatial Data Types Not Supported For Distinct UDTs
Migrating or Copying a UDT to a Different System
Related Information
CREATE TYPE (Structured Form)
Internal And External Representations Of Structured UDTs
Similarities With The Syntax For CREATE TYPE (Distinct Form)
Function of Structured UDTs
Default Capabilities of Structured UDTs
Default Cast For a Structured UDT
Default Ordering For a Structured UDT
Default Transform Group For a Structured UDT
System-Generated Constructor Functions
System-Generated Observer and Mutator Methods
Handling Character Sets
Enabling Full Functionality For a Structured UDT
SYSUDTLIB Database
Constructor Methods
Limit On the Number of Methods You Can Associate With a UDT
Assigning Structured UDTs
Effect of Platform on Storage Size of Structured UDTs
Migrating or Copying a UDT to a Different System
Related Information
CREATE USER
Maximum Number of Users and Databases Per System
How Users and Databases Differ
Reporting User Space
PERMANENT, SPOOL, and TEMPORARY Space
Purpose of the STARTUP String
USING Request Modifier in STARTUP String
Local Journaling
Activating Permanent Journaling
Specifying a Default Time Zone for a User
Related Information
CREATE VIEW and REPLACE VIEW
UDT, Period, and Geospatial Expressions in Views
CREATE and REPLACE VIEW, CREATE and REPLACE RECURSIVE VIEW
Limit On Request Size
WITH RECURSIVE Clause Usage
TOP n and TOP m PERCENT Clause Usage
TOP m PERCENT and Rounding
WHERE, HAVING, and QUALIFY Clause Usage
ORDER BY Clause Usage
Rules and Restrictions for Creating, Replacing, and Using Views
Support for Global Temporary, Global Temporary Trace, and Volatile Tables
Updatable Views
WITH CHECK OPTION Clause in Views
Joins and Aggregation in View Definitions
Joins and Aggregates on a View
SELECT Expression Can Include Data Definition Attributes
Views and the LOCKING Request Modifier
Overriding LOCKING FOR READ in a View
Using Views To Control Access To The Partitions of a PPI Table
View Definitions and Character Sets
Related Information
DATABASE - DROP USER
DATABASE
Logging Sessions On and Creating a Default Database
When Fully Qualified Names Are Required
DATABASE Statement Not Valid In 2PC Mode
Resolving Unqualified References
DELETE DATABASE
DELETE DATABASE Removes Privileges
Locks
Referenced Objects
DELETE DATABASE Does Not Delete Journal Tables
DELETE DATABASE and Global Temporary or Volatile Tables
DELETE DATABASE and Queue Tables
DELETE DATABASE and Java External Stored Procedures
DELETE DATABASE and SQL UDFs
DELETE DATABASE and Error Tables
DELETE DATABASE and Online Archive Logging
After DELETE Structure Remains Intact
DELETE DATABASE and Statistics
DELETE USER
DELETE USER Removes Privileges
Locks
Referenced Objects
DELETE USER Does Not Delete Journal Tables
DELETE USER and Global Temporary or Volatile Tables
DELETE USER and Queue Tables
DELETE USER and Java External Stored Procedures
DELETE USER and SQL UDFs
After DELETE Structure Remains Intact
DELETE USER and Statistics
DROP FUNCTION
External UDF .so Linkage Information
Dropping an Algorithmic Compression Function
Dropping a Function For Which Statistics Are Being Collected
DROP HASH INDEX
Restrictions on Dropping a Hash Index on a Table Concurrent With Dynamic AMP Sample Emulation on That Table
Considerations For Dropping Hash Indexes to Enable Client Batch Load Utilities
DROP INDEX
Reasons to Drop a Secondary Index
UNIQUE and PRIMARY INDEX Constraints
Restrictions on Dropping a Secondary Index on a Table Concurrent With Dynamic AMP Sample Emulation on That Table
Considerations For Dropping Secondary Indexes to Enable Client Batch Load Utilities
DROP JOIN INDEX
Restrictions on Dropping a Join Index on a Table Concurrent With Dynamic AMP Sample Emulation on That Table
Considerations For Dropping Join Indexes to Enable Client Batch Load Utilities
DROP MACRO
Additional DROP Processes for Java External Procedures
Referenced Objects
DROP ORDERING
Restrictions On Dropping An Ordering
Dropping System-Generated Orderings For Distinct UDTs
Effects of Dropping An Ordering On Subsequent Operations
DROP ORDERING And System-Generated Constructor UDFs
DROP STATISTICS (Optimizer Form)
Lock-Related Restrictions
Transaction-Related Restrictions
Dropping Statistics On UDT, BLOB, CLOB, Period, and Geospatial Columns
When to Use DROP and COLLECT STATISTICS
Rules and Restrictions for DROP STATISTICS
DROP TABLE
DROP Processes for DROP TABLE
Locks for DROP TABLE
DROP TABLE and Queue Tables
DROP TABLE and Error Tables
DROP TABLE and Statistics
DROP TRANSFORM
Function of DROP TRANSFORM
Restrictions On Dropping A Transform
DROP TRANSFORM And System-Generated Constructor UDFs
DROP USER
Journal Tables and DROP USER
Join and Hash Indexes and DROP USER
Triggers and DROP USER
Query Bands and DROP USER
DBQL Rules and DROP USER
Dropping a Populated User
DROP Processes
Locks
Drop Processes and Java External Procedures
Referenced Objects
END LOGGING - SET TIME ZONE
END QUERY LOGGING
Query Logging and SQL Transactions
Determining Whether an Account Was Specified for BEGIN QUERY LOGGING
Effect of END QUERY LOGGING on the Contents of DBQL Caches
Resetting Use Counts and Timestamps
Removing All Query Logging Rules
Related Information
FLUSH QUERY LOGGING
FLUSH QUERY LOGGING Advantages
Flushing Options
Advantages of Manually Flushing Query Logs
Performance Issues
Related Information
MODIFY DATABASE
Specifying Multiple Options
Two or More Databases and Users Can Share a Journal Table
A Dropped Journal Table Cannot Be Restored
Changing the Default Journal Table Contained Within the Modified Database
Local Journaling
Activating Permanent Journaling
Locks and Concurrency
Related Information
MODIFY USER
Option Checking
STARTUP Options
TIME ZONE Option
DEFAULT DATABASE
Modifying the Default Time Zone for a User
Two MODIFY Requests Required to Change Default Journal Table
Activating Permanent Journaling
A Dropped Journal Table Cannot Be Restored
Multiple Databases and Users Can Share a Journal Table
Local Journaling
Locks and Concurrency
Related Information
RENAME FUNCTION (External Form)
RENAME FUNCTION (External Form) and UDTs
RENAME FUNCTION (External Form) Changes Only One Function Name Per Request
RENAME FUNCTION (External Form) Does Not Change the C or C++ Function Name
RENAME FUNCTION (External Form) and Algorithmic Compression
Character Set Issues for Renaming External Functions
Rules for Renaming Overloaded Calling Names
Rule for Renaming Specific External Function Names
RENAME FUNCTION (SQL Form)
Rule for RENAME FUNCTION (SQL Form) and the Function Body
RENAME FUNCTION (SQL Form) Changes Only One Function Name Per Request
Rules for Renaming Overloaded Calling Names
Rule for Renaming Specific SQL Function Names
RENAME PROCEDURE
Qualifying an Object From Another Database
Character Set Issues for Renaming Methods
Locks and Concurrency
RENAME TABLE
Qualifying an Object From Another Database
Locks and Concurrency
Renaming Volatile and Global Temporary Tables
Tables That Have Hash or Join Indexes Cannot Be Renamed
Function of RENAME Table Requests
RENAME VIEW
Qualifying an Object From Another Database
Locks and Concurrency
REPLACE METHOD
Prerequisites to Replacing a Method
Function of REPLACE METHOD
How REPLACE METHOD And CREATE METHOD Differ
Restrictions On The Replacement Of Methods That Implement Ordering Or Transform Operations On UDTs
Character Set Issues for Renaming Methods
REPLACE QUERY LOGGING
REPLACE QUERY LOGGING Avoids the Problems of Ending an Existing Query Logging Rule Set
Related Information
SET QUERY_BAND
SET QUERY_BAND Syntax Rules
Function of Query Bands
Query Bands and Session-Level Performance
Query Bands and Trusted Requests
Query Bands and Trusted Sessions
Query Bands, Trusted Sessions, and Row-Level Security
Differences Between Setting a Query Band for a Session and for a Transaction
High-Level Process for Trusted Sessions
Discretionary Access Control Security Issues With Trusted Sessions
Query Bands, Trusted Sessions, and Connection Pooling
Using SET QUERY_BAND Requests to Make Proxy User Connections
Query Bands, Trusted Sessions, and Multistatement Requests
Query Bands, Trusted Sessions, and Roles
SET QUERY_BAND FOR SESSION, Proxy Users, and the Deletion of Volatile and Global Temporary Tables
Query Bands and External Routines
Query Bands and Teradata Viewpoint/Database Query Log
Query Bands and Load Utilities
Open API SQL Interfaces To Support Query Banding
Other Methods of Retrieving Query Band Information
Reserved Query Band Names and Values
Load Utility Reserved Query Bands
Reserved Storage Management Query Bands
Incremental Planning and Execution (IPE) Query Bands
BlockCompression Reserved Storage Management Query Bands
TVSTemperature Reserved Storage Management Query Bands
Reserved Redrive Query Band
Related Information
SET SESSION CALENDAR
Rules and Restrictions for SET SESSION CALENDAR
System-Defined Calendars
Business Calendar UDFs
SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL
Definition of Isolation Level
Default Session Transaction Isolation Level
Why Default to ACCESS Locks For All SELECT Operations Embedded Within DELETE, INSERT, and UPDATE Requests in a Session?
Correspondence Between ANSI SQL Transaction Isolation Levels and Database Locks
Related Information
SET SESSION FUNCTION TRACE
Trace Library Function Calls
Possible Uses for SET SESSION FUNCTION TRACE
SET SESSION FUNCTION TRACE Performance Overhead
Function Trace Output Table
SET TIME ZONE
Setting the Permanent Default Time Zone for Your System
UTC Definition
General Rules for Using SET TIME ZONE
Rules and Restrictions for Specifying Simple Expressions for Time Zones
Daylight Saving Time and Time Zone Strings Specified As Time Zone Strings
Time Zone Strings
SQL HELP Statements
About HELP Statements
SQL HELP Statement Reports
HELP (Online)
HELP Usage Notes
Formatting HELP Report Results
Object Name and Title Data in HELP Reports
Translating HELP Report Data into the Session Character Set
Rules for HELP Report Names and Titles
Example Object Name in HELP Output
Determining the SQL Name or SQL Title Delimiter Character
Using an SQL Name or SQL Title Value in an SQL Request
Data Type Codes
TVM Kind Codes
HELP CAST
HELP CAST Attributes
Example: Source Castings Only
Example: Target Castings Only
Example: All Castings For A UDT That Has A Single Casting Pair
Example: All Castings For A UDT That Has Multiple Casting Pairs
Related Information
HELP COLUMN
HELP COLUMN With a FROM Clause
HELP COLUMN For a Data Table Or Error Table
HELP COLUMN and Indexes
HELP COLUMN Information and Attributes
HELP COLUMN and Column-Partitioned NoPI Tables and Join Indexes
HELP COLUMN Attributes
HELP CONSTRAINT
HELP CONSTRAINT and Row-Level Security Constraints
HELP CONSTRAINT and Non-Updatable Views
Supported Named Constraint Types
CHECK Constraint Attributes
Referential Constraint Attributes
UNIQUE Constraint Attributes
HELP DATABASE
HELP DATABASE Attributes
HELP ERROR TABLE
System-Defined Attribute Characteristics for the Error Table-Specific Columns
Information Returned By The Different Syntax Forms Is Identical
HELP FUNCTION
User-Defined Function Attributes
HELP HASH INDEX
Hash Index Attributes
HELP INDEX Usage Restriction
HELP INDEX
HELP INDEX Usage Restriction
HELP INDEX and Non-Updatable Views
HELP INDEX and Partitioned Primary Indexes
HELP INDEX and Unindexed Tables
HELP INDEX and NoPI Tables, Column-Partitioned Tables, and Column-Partitioned Join Indexes
HELP INDEX and Hash, Join and Covering Indexes
HELP INDEX Attributes
HELP JOIN INDEX
Join Index Attributes
HELP MACRO
Macro Attributes
HELP METHOD
HELP METHOD Only Valid For User-Defined Methods
SELF Parameter
HELP METHOD Attributes
HELP PROCEDURE
Procedure Parameter Attributes
Procedure Attributes
HELP SESSION
Session Attributes
HELP SESSION CONSTRAINT
Session Constraint Attributes
HELP STATISTICS (Optimizer Form)
HELP STATISTICS Usage Restriction
Locks and Concurrency
HELP STATISTICS and Non-Updatable Views
Support for Global Temporary and Volatile Tables
How HELP STATISTICS Behaves When No Statistics Exist
Summary Optimizer Statistics Attributes
Related Information
HELP STATISTICS (QCD Form)
HELP STATISTICS and Non-Updatable Views
How HELP STATISTICS Behaves When No Statistics Exist
How To Report Summary and Detailed Statistics HELP
Summary QCD Statistics Attributes
Statistics Attribute Definitions
Related Information
HELP TABLE
HELP TABLE and Column-Partitioned NoPI Tables and Join Indexes
Table, Hash Index, and Join Index Attributes
Table Columns
HELP TRANSFORM
HELP TRANSFORM Attributes
HELP TRIGGER
Trigger Attributes
HELP TYPE
General Type Attributes
Attributes Reported by the ATTRIBUTE Option
Attributes Reported by the METHOD Option
HELP USER
HELP USER Attributes
HELP VIEW
View Attributes
View Columns
HELP VOLATILE TABLE
Volatile Table Attributes
HELP (Online Form)
Online HELP Compared with SQL HELP Statements
Notation for Online Help
Topic Keywords
Error on Request for Help on a Nonexistent Topic
Response Format
SQL SHOW Statements
About SHOW Statements
Using SHOW Statements
CHARACTER SET Support for SHOW Requests
Unprintable Characters in Object Names and Literals Returned by SHOW
SHOW request
Report Structure
Restrictions
SHOW and Column Partitioning
SHOW and the IN XML Option
SHOW object
SHOW and Embedded SQL
SHOW CAST
SHOW CONSTRAINT
IN XML Option for SHOW Requests
Limitations in the Application of SHOW JOIN INDEX IN XML and SHOW VIEW IN XML
Standard Form of Display for SHOW JOIN INDEX for Aggregate Join Indexes
SHOW MACRO, SHOW VIEW, and Semantic Definition Errors
When the Actual User or Database Does Not Match the Definition Reported by SHOW MACRO or SHOW VIEW
SHOW METHOD
SHOW PROCEDURE For Java External Procedures
Standard Form of Display for SHOW TABLE
SHOW TABLE If DATABLOCKSIZE or FREESPACE Has Been Modified
Applications of SHOW TABLE IN XML and SHOW HASH INDEX IN XML
SHOW TABLE Support for Global Temporary and Volatile Tables
SHOW TABLE, SHOW JOIN INDEX, and Column Partitioning
SHOW TABLE and Language Support Mode of a System
SHOW TYPE
SHOW QUERY LOGGING
Alternative Method for Determining Query Logging Rules
Rules Hierarchy for SHOW QUERY LOGGING
SHOW STATISTICS
Applicability of SHOW STATISTICS Requests
Rules and Guidelines for SHOW STATISTICS Requests
About the SEQUENCED Option
Rules, Restrictions, and Usage Guidelines for the SEQUENCED Option
Response Sequences for Detailed Statistics (Record and Indicator Modes)
Locks and Concurrency
Detailed Interval Statistics Can Change From One Release To The Next
Detailed Interval Statistics Attributes (Field Mode)
Response Sequences for Detailed Statistics (Record and Indicator Modes)
Additional Information
Teradata Links
A column-partitioned table can have a primary index, a primary AMP index, or no primary index.
If you do not specify a PRIMARY INDEX or PRIMARY AMP clause or if you do specify a NO PRIMARY INDEX clause and you also specify a PARTITION BY clause, the partitioning must specify a COLUMN partitioning level.
If you do not specify a PRIMARY INDEX (column_list ) clause, PRIMARY AMP INDEX clause, or NO PRIMARY INDEX clause explicitly in your CREATE TABLE statement, but you do specify a PARTITION BY clause, then Vantage creates the table without a primary index.