By default, when you create a table, it has no expiration date. To give a table an expiration date, use the SAVE statement as described in the SQL Reference Guide.

A table is not automatically destroyed on its expiration date.