15.10 - Changes to this Book - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
Release Description

Teradata Database 15.10

December 2015

UDF Debugger

CREATE METHOD, EXTERNAL, Initial Code, added D option.

SET SESSION DEBUG FUNCTION, added method.

Teradata Database 15.10

July 2015

Binary JSON

HELP COLUMN Examples updated to include Storage Format column.

Query Logging

BEGIN QUERY LOGGING, updated WITH USECOUNT option.

REPLACE QUERY LOGGING, updated WITH USECOUNT option.

Teradata Database 15.10

June 2015

Aggregate Enhancements

CREATE JOIN INDEX, updated COUNT.

Binary JSON

APPENDIX B Object Data Types, Data Types Syntax updated for Binary JSON.

Checksum

CREATE TABLE, updated CHECKSUM option.

CREATE JOIN INDEX, updated CHECKSUM option.

CREATE HASH INDEX, updated CHECKSUM option.

Column Partitioning with Primary AMP Index or Primary Index

CREATE TABLE, revised CREATE TABLE and CREATE TABLE AS Syntax diagrams, revised PRIMARY INDEX option, added PRIMARY AMP option.

ALTER TABLE, revised Syntax diagram and MODIFY PRIMARY option.

CREATE INDEX, index_column_name revised.

CREATE JOIN INDEX, revised PRIMARY INDEX, added PRIMARY AMP option.

Compression Visibility

COLLECT STATISTICS SUMMARY option.

SHOW STATISTICS SUMMARY option.

Load Isolation

CREATE TABLE, added WITH ISOLATED LOADING option.

ALTER TABLE, added WITH ISOLATED LOADING option, RELEASE ROWS option

CREATE VIEW and REPLACE VIEW, revised LOCKING Clause.

CREATE INDEX, updated Syntax diagram, added WITH LOAD IDENTITY option.

SET SESSION, added SET SESSION FOR ISOLATED LOADING.

Logging WITH NO COLUMNS OBJECTS Option

BEGIN QUERY LOGGING, updated Syntax diagram, added NO COLUMNS option.

Object Naming

Removed references to 30-character limits for object names. Teradata Database supports object names up to 128 characters long in most cases. For information about naming database objects, see SQL Fundamentals, B035-1141.

Query Band option for Profile

CREATE PROFILE, updated Syntax diagram, added QUERY_BAND option.

MODIFY PROFILE, updated Syntax diagram, added QUERY_BAND option.

Query Capture Update for Index Workload

BEGIN QUERY CAPTURE, updated Syntax diagram, added FOR INDEX_ANALYSIS option.

Secure Zones

Added Secure Zones chapter including CREATE ZONE statement, ALTER ZONE statement, and DROP ZONE statement.

CREATE USER, updated Syntax diagram, added DBA option

MODIFY USER, updated Syntax diagram, added DBA option.

UDF Debugger

CREATE FUNCTION (External Form) and REPLACE FUNCTION (External Form), updated Syntax diagram, added D option.

CREATE PROCEDURE and REPLACE PROCEDURE (External Form), updated Syntax diagram, added D option

SET SESSION DEBUG FUNCTION added.