Create temporary table in database other than tempdb

Marios Meimaris 1 Reputation point
2021-11-05T12:24:43.727+00:00

Is it possible to create a temporary table in a database other than tempdb in synapse?

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,422 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,576 Reputation points
    2021-11-08T07:52:45.623+00:00

    Hi @Marios Meimaris , welcome to Microsoft Q&A forum.

    Temporary tables are created in temp database only. If we refer to below article, after creation of temp tables we check the existence in temp db:

    Temporary tables in Synapse SQL

    Could you please provide the use case of using the temp table in other dbs, so we can check if there is any alternate we can use?

    0 comments