How cool are User Defined Data Types in SQL Server?

sql sql-server user-defined-types
David Vidmar picture David Vidmar · Mar 18, 2009 · Viewed 34.3k times · Source

Are User Defined Data Types in SQL Server something that a intermediate SQL user should know and use?

What are pros and cons of using UDTs?

Answer

HLGEM picture HLGEM · Mar 18, 2009

Never use them is my advice. You are in a world of hurt if you ever have to change the definition. Perhaps this has improved since SQL Server 2000 and someone with more familiarity with the newer versions can tell you whether it is now safe to get in the water, but until I had confirmation of this and had checked it out myself with a test, I wouldn't put it on my production system.

Check out this question for details: How to change the base type of a UDT in Sql Server 2005?

Related questions

How to check existence of user-define table type in SQL Server 2008?

I have a user-defined table type. I want to check it's existence before editing in a patch using OBJECT_ID(name, type) function. What type from the enumeration should be passed for user-defined table types? N'U' like for user defined …

Read More
Unable to Modify User-Defined Table Type

I have a SQL User-Defined Table Type. It used in many stored procedures.Now i need to change a column in that table type. I tried to drop and recreate the User-Defined Table Type.But SQL Server doesn't Allow that. …

Read More
SQL Server create User-Defined Table Types with schema not working properly

I'm creating User-Defined Table Types on SQL Server 2008R2/2012 with this statement: CREATE TYPE [MySchemaName].[MyUserTableType] As Table ( [Id] varchar(20) NOT NULL ); This works as intended. I also got a stored procedure which deletes all associated object to a given …

Read More