Usage Notes - Advanced SQL Engine - Teradata Database
SQL Data Definition Language Syntax and Examples
- Product
- Advanced SQL Engine
- Teradata Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-27
- dita:mapPath
- spp1591731285373.ditamap
- dita:ditavalPath
- spp1591731285373.ditaval
- dita:id
- B035-1144
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- You cannot use ALTER FOREIGN TABLE to drop the location or payload column.
- You cannot use ALTER FOREIGN TABLE to change the location column.
- ALTER FOREIGN TABLE enforces the following rules for Parquet foreign columnar tables:
- No row partitioning (column_option cannot specify ROW and update_specification cannot specify ROWFORMAT)
- No subrow partitioning
- No multicolumn partitions
- No autocompression (column_option cannot specify AUTOCOMPRESS)