General Rules for Temporary Tables

Temporary tables with names that begin with # are subject to certain restrictions.

The restrictions are:

You cannot create views on these tables.
You cannot associate triggers with these tables.
From within a stored procedure, you cannot:
1. Create a temporary table
2. Drop it
3. Create a new temporary table with the same name.
You cannot tell which session or procedure has created these tables.

These restrictions do not apply to shareable, temporary tables that are created in tempdb.

Rules that apply to both types of temporary tables:

You can associate rules, defaults, and indexes with temporary tables. Indexes created on a temporary table disappear when the temporary table disappears.
System procedures, such as sp_help, work on temporary tables only if you invoke them from tempdb.
You cannot use user-defined datatypes in temporary tables unless the datatypes exist in tempdb; that is, unless the datatypes have been explicitly created in tempdb since the last time SAP ASE was restarted.
You do not have to set the select into/bulkcopy option on to select into a temporary table.