SQLプロシージャでサポートされるDDL文 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQLデータ定義言語 詳細トピック
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
2020年6月
ft:locale
ja-JP
ft:lastEdition
2021-03-30
dita:mapPath
ja-JP/jpx1556733107962.ditamap
dita:ditavalPath
ja-JP/jpx1556733107962.ditaval
dita:id
B035-1184
Product Category
Software
Teradata Vantage

Teradataは、次のSQLプロシージャのSQL DDL文をサポートします。

  • ALTER FUNCTION
  • ALTER TABLE
  • ALTER TABLE TO CURRENT
  • ALTER TRIGGER
  • BEGIN LOGGING
  • COLLECT STATISTICS (最適化ルーチン形式)
  • COMMENT
  • CREATE CAST
  • CREATE DATABASE
  • CREATE ERROR TABLE
  • CREATE FUNCTION (外部形式)
  • CREATE FUNCTION (SQL形式)
  • 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 (最適化ルーチン形式)
  • DROP TABLE
  • DROP TRANSFORM
  • DROP TRIGGER
  • DROP USER
  • DROP VIEW
  • END LOGGING
  • MODIFY DATABASE
  • MODIFY PROFILE
  • MODIFY USER
  • RENAME FUNCTION (外部形式)
  • RENAME FUNCTION (SQL形式)
  • RENAME MACRO
  • RENAME PROCEDURE
  • RENAME TABLE
  • RENAME TRIGGER
  • RENAME VIEW
  • REPLACE CAST
  • REPLACE FUNCTION
  • REPLACE FUNCTION (SQL形式)
  • REPLACE MACRO
  • REPLACE ORDERING
  • REPLACE TRANSFORM
  • REPLACE TRIGGER
  • REPLACE VIEW
  • SET QUERY_BAND … FOR TRANSACTION