Unable to create TYPE (User-defined Type) in Azure synapse dedicated sql pool

Raheel Islam 21 Reputation points
2024-02-08T04:57:41.3133333+00:00

I am unable to create a user defined table type in Azure Synapse dedicated SQL pool. I am getting follwoing error when creating a Type (User-defined Type) User's image

SQL Server and Azure SQL Server support to CREATE TYPE and we are migration from Azure SQL Server to Azure Synapse dedicated SQL pool. Does Azure Synapse Dedicated sql pool supports user defined table types? else do we have any alternative for this. Thanks Raheel

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,115 questions
{count} votes

Accepted answer
  1. Vinodh247 9,071 Reputation points
    2024-02-08T05:45:58.4233333+00:00

    Hi , Thanks for reaching out to Microsoft Q&A.

    Seems it's not supported, and the workaround will be to use temp tables instead. To not duplicate the answer, I am providing the link below, which was already answered by kranthipakala for a similar question. Pls go through and let me know if this helped.

    https://learn.microsoft.com/en-us/answers/questions/1135813/unable-to-create-user-defined-table-type-in-azure

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful