Create Temporary Table with table-type

[acaireta]

In HANA is possible to create a temporary table with the structure already defined in a TYPE?

EXAMPLE: 

CREATE TYPE MY_TYPE as TABLE(
              col1 varchar(1),
               col2 integer)
CREATE LOCAL TEMPORARY TABLE #TMP_TBL WITH MY_TYPE

Fore more information, I have HANA PLATFORM Rev. 53.

Thanks very much.

[Former Member]

Hi,

I'm without an env to test, but you can try to use LIKE instead WITH.

CREATE LOCAL TEMPORARY TABLE #TMP_TBL LIKE MY_TYPE

Best regards