Temporary Tables - MarkMpn/Sql4Cds GitHub Wiki

SQL 4 CDS allows you to create temporary tables to store data outside of your actual Dataverse database.

The following statements are supported for use with temporary tables:

• CREATE TABLE
• SELECT
• INSERT
• UPDATE
• DELETE
• DROP TABLE

The CREATE TABLE and DROP TABLE statements are only supported with temporary tables - they cannot be used to create or drop persistent tables within Dataverse.

Storage

Temporary tables are always stored in memory only. As such they are only intended to be used for very small datasets.

Restrictions

Only a basic set of options are supported for the CREATE TABLE statement. Constraints except NOT NULL, indexes, identity definitions, computed columns and many more options are unsupported and will generate an error.