How to ALTER the Table Value Parameter

Question

i am not getting option like 'ALTER To' when am right clicking on TVP

Answer 1

Can't do it. You must drop/recreate. If you have dependencies on the TVP, you must:

1. create new TVP under new name
2. alter dependencies to use (1)
3. drop old TVP
4. recreate (1) under original name
5. alter dependencies to use (4)
6. drop (1)

Answer 2

Thank u frnd........................

Answer 3

i am using TVP in StoredProcedure at the end of my sp i need to TRUNCATE