15.00 - Supported DDL Statements in SQL Procedures - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Supported DDL Statements in SQL Procedures

Teradata Database supports the following SQL DDL statements for SQL procedures.

 
  • ALTER FUNCTION
  • ALTER TABLE
  • ALTER TABLE TO CURRENT
  • ALTER TRIGGER
  • BEGIN LOGGING
  • COLLECT STATISTICS (Optimizer Form)
  • COMMENT
  • CREATE CAST
  • CREATE DATABASE
  • CREATE ERROR TABLE
  • CREATE FUNCTION (External Form)
  • CREATE FUNCTION (SQL Form)
  • CREATE HASH INDEX
  • CREATE INDEX
  • CREATE JOIN INDEX
  • CREATE MACRO
  • CREATE ORDERING
  • CREATE PROFILE
  • CREATE RECURSIVE VIEW
  • CREATE ROLE
  • CREATE TABLE
  • CREATE TRANSFORM
  • CREATE TRIGGER
  • CREATE USER
  • CREATE VIEW
  • DELETE DATABASE
  • DELETE USER
  • DROP CAST
  • DROP DATABASE
  • DROP HASH INDEX
  • DROP INDEX
  • DROP JOIN INDEX
  • DROP MACRO
  • DROP ORDERING
  • DROP PROCEDURE
  • DROP PROFILE
  • DROP ROLE
  • DROP STATISTICS (Optimizer Form)
  • DROP TABLE
  • DROP TRANSFORM
  • DROP TRIGGER
  • DROP USER
  • DROP VIEW
  • END LOGGING
  • MODIFY DATABASE
  • MODIFY PROFILE
  • MODIFY USER
  • RENAME FUNCTION (External Form)
  • RENAME FUNCTION (SQL Form)
  • RENAME MACRO
  • RENAME PROCEDURE
  • RENAME TABLE
  • RENAME TRIGGER
  • RENAME VIEW
  • REPLACE CAST
  • REPLACE FUNCTION
  • REPLACE FUNCTION (SQL Form)
  • REPLACE MACRO
  • REPLACE ORDERING
  • REPLACE TRANSFORM
  • REPLACE TRIGGER
  • REPLACE VIEW
  • SET QUERY_BAND … FOR TRANSACTION