Altering user-defined table types in SQL Server

sql-server user-defined-types
yogi picture yogi · Jul 10, 2012 · Viewed 122.8k times · Source

How can I alter a user-defined table type in SQL Server ?

Answer

Manivannan Nagarajan picture Manivannan Nagarajan · Jan 23, 2013

As of my knowledge it is impossible to alter/modify a table type.You can create the type with a different name and then drop the old type and modify it to the new name

Credits to jkrajes

As per msdn, it is like 'The user-defined table type definition cannot be modified after it is created'.

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
How cool are User Defined Data Types in SQL Server?

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?

Read More
SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?

Here's my user-defined table type... CREATE TYPE [dbo].[FooType] AS TABLE( [Bar] [INT], ) This is what ive had to do in my table-valued function to return the type: CREATE FUNCTION [dbo].[GetFoos] RETURN @FooTypes TABLE ([Bar] [INT]) INSERT INTO @FooTypes (1) …

Read More