ALTER FOREIGN TABLE SQL Statement | Teradata Database - ALTER FOREIGN TABLE - Teradata Database

SQL Data Definition Language Syntax and Examples
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Database
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-09-23
dita:mapPath
mbm1747160743883.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
mdr1472255012272
lifecycle
latest

ALTER FOREIGN TABLE can change the schema, attributes, or partitioning of a specified foreign table.

To see the foreign table definition, use SHOW TABLE.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

You must have the DROP TABLE privilege on the foreign table that you want to alter.