- 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)