General Rules for Temporary Tables

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

The restrictions are:

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

Rules that apply to both types of temporary tables: