Jegatheesan
Reputation: 115
Azure Synapse analytics temporary table DDL
Is there any way we can view the definition of a temporary table in Azure Synapse.
I tried in sys.tables but it is not available.
Upvotes: 0
Views: 1454
Answers (1)
Rahul Pandey
Reputation: 305
Temporal table in Azure Synapse is limited to session only.They are only visible to the session in which they are created and automatically dropped when session logs off.
Upvotes: 0
Related Questions
- External Table in Azure synapse very slow performance
- Table Details in Azure Datawarehouse
- Azure Synapse External Table Location parameterization
- Not able to create table in Azure Synapse Analytics
- Error with CTAS - Azure Synapse Analytics
- In Azure Synapse, is it true that creating a temporary table is discouraged?
- querying of SQL table with dynamic date filter in Azure data factory (Azure synapse analytics)
- Synapse Analytics - Can't see the tables list in the dedicated sql pool
- Azure Synapse Analytics query timeout
- External table Azure Synapse does't returning data