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.