How to ALTER the Table Value Parameter
sql-server, t-sql, table-valued-parameters
Solution
Can't do it. You must drop/recreate. If you have dependencies on the TVP, you must:
- create new TVP under new name
- alter dependencies to use (1)
- drop old TVP
- recreate (1) under original name
- alter dependencies to use (4)
- drop (1)
Problem
I am not getting option like 'ALTER TO' when am right clicking on TVP