Unlike tables, a table type cannot be altered by a simple command. I need to do the following:
- Rename existing table type
- Create the new table type
- Open each affected objects (i.e. ALTER SP) and execute it again so that the reference to table type will be updated.
But this is a tedious task as there may be many SP to be updated. Is there any easy way/pre-generated script that can automate this process?