I am not getting option like 'ALTER TO' when am right clicking on TVP
Can't do it. You must drop/recreate. If you have dependencies on the TVP, you must:
548k questions
547k answers
4 comments
86.3k users