DDL statements in Teradata

Teradata has the following list of Data Definition statements.

ALTER
• ALTER FUNCTION
• ALTER METHOD
• ALTER PROCEDURE
• ALTER REPLICATION GROUP
• ALTER TABLE
• ALTER TRIGGER
• ALTER TYPE


GENERAL
• BEGIN LOGGING
• COMMENT
• END LOGGING
• DATABASE


CREATE
• CREATE AUTHORIZATION
• CREATE CAST
• CREATE DATABASE
• CREATE FUNCTION
• CREATE HASH INDEX
• CREATE INDEX
• CREATE JOIN INDEX
• CREATE MACRO
• CREATE METHOD
• CREATE ORDERING
• CREATE PROCEDURE
• CREATE PROFILE
• CREATE REPLICATION GROUP
• CREATE ROLE
• CREATE TABLE
• CREATE TRANSFORM
• CREATE TRIGGER
• CREATE TYPE
• CREATE USER
• CREATE VIEW


DROP
• DROP AUTHORIZATION
• DROP CAST
• DROP DATABASE
• DROP FUNCTION
• DROP HASH INDEX
• DROP INDEX
• DROP JOIN INDEX
• DROP MACRO
• DROP ORDERING
• DROP PROCEDURE
• DROP PROFILE
• DROP REPLICATION GROUP
• DROP ROLE
• DROP TABLE
• DROP TRANSFORM
• DROP TRIGGER
• DROP TYPE
• DROP USER
• DROP VIEW




MODIFY
• MODIFY DATABASE
• MODIFY PROFILE
• MODIFY USER



RENAME
• RENAME FUNCTION
• RENAME MACRO
• RENAME PROCEDURE
• RENAME TABLE
• RENAME TRIGGER
• RENAME VIEW



REPLACE
• REPLACE CAST
• REPLACE FUNCTION
• REPLACE MACRO
• REPLACE METHOD
• REPLACE ORDERING
• REPLACE PROCEDURE
• REPLACE TRANSFORM
• REPLACE TRIGGER
• REPLACE VIEW


SET
• SET ROLE
• SET SESSION
• SET TIME ZONE