Hello
I have a user-defined data type like below which I want to change from SMALLINT to INT.
But the problem is this column is connected to many tables and store procedures more than 100 procedure and 30 tables
CREATE TYPE [dbo].[typIDBusinessZoneProcess]
FROM SMALLINT NOT NULL;
I found some links but not sure which one i need to use
https://dba.stackexchange.com/questions/196482/how-to-do-alter-table-type-efficiently
https://www.mssqltips.com/sqlservertip/6114/how-to-alter-user-defined-table-type-in-sql-server/