CREATE LOCAL TEMPORARY TABLE T1(ID BIGINT PRIMARY KEY);

SELECT TABLE_NAME, TABLE_TYPE FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'PUBLIC';
> TABLE_NAME TABLE_TYPE
> ---------- ---------------
> T1         LOCAL TEMPORARY

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS;
> No rows

SELECT * FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE;
> No rows

SELECT TABLE_NAME, INDEX_TYPE_NAME FROM INFORMATION_SCHEMA.INDEXES;
> TABLE_NAME INDEX_TYPE_NAME
> ---------- ---------------
> T1         PRIMARY KEY