Supported DDL Statements in Procedures | CREATE PROCEDURE | Teradata Vantage - Supported DDL Statements in SQL Procedures - 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™

Teradata 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