Is it possible to create a temporary table in a database other than tempdb in synapse?
Hi @MariosMeimaris-8377, 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:
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?
11 people are following this question.