question

MariosMeimaris-8377 avatar image
0 Votes"
MariosMeimaris-8377 asked AnuragSharma-MSFT answered

Create temporary table in database other than tempdb

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

azure-sql-databaseazure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered

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:

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?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.