changing data type in userdef tabletype
Posted on 2013-10-18
for changing type in table, it is easy:
alter table table1 alter column column1 smallint not null
but it is not straight forward in user defined table type..
(CREATE TYPE abc AS TABLE(column list)
right now to change the data type in the column list within the table type, we have to drop the defined data type and add it back.. if there are any dependencies, they need to be dropped also..
if you have any suggestions to simplify this, when you have to change a type, please share.