NOPI Option | CREATE FOREIGN TABLE | Teradata Vantage - 17.00 - NO PRIMARY INDEX - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
September 2020
Content Type
Programming Reference
Publication ID
English (United States)

The foreign table is created without a primary index. This is the default and the required setting.

Foreign tables are always NOPI tables. A primary index, secondary index, join index, or hash index cannot be defined on a foreign table.