Using Temporal tables with SQL script

[Former Member]

Hello, We are using temporal tables in the following way in STPs: CREATE LOCAL TEMPORARY TABLE #t_fact_ZLEGALENT("LEGAL_ENTITY" NVARCHAR(4)); What kind of table is created? (row or column store?) Is there a way to see this table? Thanks, Amir

[rindia]

Hi Amir,

You can find the metadata (not actual data) in M_TEMPORARY_TABLE_COLUMNS

Also your table cannot be found in the schema where you created.

Regards

Raj

[former_member182302]

Hi Amir,

CREATE LOCAL TEMPORARY TABLE -- will create a row

CREATE LOCAL TEMPORARY COLUMN TABLE -- will create a columnar

Have a look on this link:

CREATE TABLE - SQL Reference - SAP Library

Regards,

Krishna Tangudu