How to create an alias for a datatype on Fabric?

[csubhodeep]

Hello,

Is is possible to create an alias for a datatype on Fabric? I know we can do it on MS SQL Server by running the following

CREATE TYPE dbo.VARCHAR_MAX FROM VARCHAR(255);

I am asking this because a lot of our queries and tables that currently live on MS SQL Server have the data type `VARCHAR(MAX)` which is not compatible with Fabric (as shown in the screenshot)

[AndyDDC · Accepted solution]

Hi @csubhodeep if appropriate, can you mark an answer here as accepted to close the issue?

[v-huijiey-msft]

Hi @csubhodeep ,

AndyDDC is right, his answer works like a charm!

I tested it and CREATE TYPE is not supported.

Is it important for you to create aliases for data types on Fabric? If so, you can submit a suggestion on Home (microsoft.com).

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[AndyDDC]

Hi @csubhodeep no it doesn't look like CREATE TYPE is support.  There os no mention of it in the T-SQL Surfce Area (limitations) doc though T-SQL surface area - Microsoft Fabric | Microsoft Learn

Keep an eye out on the roadmap What's new and planned for Synapse Data Warehouse in Microsoft Fabric - Microsoft Fabric | Microsoft...

---------------------------------------------------

If my reply has been helpful please consider

providing kudos (thumbs up).  If it has solved

your issue please consider marking as the solution

to close the thread off.

---------------------------------------------------