Limitations on wide tables

Wide tables do not have a fixed schema, but a schema which varies from query to query. They are transient tables, existing for the duration of one query only. For this reason, they must be accessed using the OPENQUERY function, which bypasses many of the tests and requirements associated with fixed tables. Wide tables support up to 1024 columns.

For more information on wide tables, see "Wide" History Table Format in the AVEVA Historian Database Reference.