在 SQL Server 中更改用户定义的表类型
问题描述:
如何在 SQL Server 中更改用户定义的表类型?
How can I alter a user-defined table type 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
感谢 jkrajes
根据 msdn,它就像用户自定义表类型定义创建后不可修改'.
As per msdn, it is like 'The user-defined table type definition cannot be modified after it is created'.