Reputation: 115
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
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