In-Memory Database Guide : Working with in-memory tables : Creating temporary and transient tables
  
Creating temporary and transient tables
By default, when you create an in-memory table, the table is persistent. To create temporary or transient tables, use the keyword TEMPORARY or TRANSIENT.
See also
Creating temporary tables
Creating transient tables
Working with in-memory tables