These are temporary tables.

Basically it means they are stored in tempdb (one of the system databases) and are dropped when the connection is terminated or when SQL Server is restarted.

They behave like any other table, so you can create them with CREATE TABLE #myTempTable or with SELECT ... INTO #myTempTable.

You can use ALTER TABLE and add indexes if you want.