Altering user-defined table types in SQL Server

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’.

Leave a Comment