Temporarily Turn Off Table Type Reference Checking On A Development Database During my database design process I have begun to add Table Types to the database and have run into the need to alter a table type. It is painfully clear that one cannot remove or drop the table type if it is being used in stored procedure(s); and unless one drops the related sprocs first, the table type can't be dropped/altered.
I get why the table type is important in an active database and why it should not be dropped if live, but if one is in a development mode is there/why not be able to turn off the database, so to drop the table type, and the add the modified type and restart? ...
 So is there a way to stop the checking and allow the drop of the table type, hence avoid the warnings to be able to alter the type?
No, there is no way to alter a table type, or drop it while any object references it directly. It would be nice to have a &quot;just trust me, I know what I'm doing&quot; mode, but we don't; you'll have to file a feature request to get that functionality.
In the meantime, what I would suggest is to just create a new table type, and then update the stored procedures in the order that they need to use the new type's definition. This prevents breaking the old procedures until you can modify them, too. A little more info here:

How to Alter User Defined Table Type in SQL Server