Changes and Additions | SQL DDL Detailed Topics | Teradata Vantage - Changes and Additions - Advanced SQL Engine

Changes and Additions | SQL DDL Detailed Topics | Teradata Vantage - Changes and Additions - 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

Product Category

Teradata Vantage™

Date	Description
July 2021	Fallback subtables are no longer compressed by default. Updated Block-Level Compression and Tables and BlockCompression Reserved Storage Management Query Bands. DEFINER and INVOKER authorizations are deprecated for NOS (updated DEFINER and INVOKER Authorizations). You can now create error tables for foreign tables (see Rules and Restrictions for Error Tables and Error Logging Limits).
June 2020	Recommendation on storing source files on the server changed to storing the files on the client system, except on Intellicloud systems. Source files on Intellicloud systems must reside on the database server.EXTERNAL NAME Clause