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

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)