thanx a lot .

i have modified some types using this method , but , when the types are used in a stored procedure what to do ? sp_droptype is not allowing me to drop it ..