DDL commands that affect temporary objects, which lack a permanent object ID, are local.
Local temporary tables
Local procedures
Temporary options