Subject Resizing fields data type

Hi All,

I need to resize 
fields  data type (numeric length and scale) of certain tables but I cannot do it du to dependencies (views and stored procedures). Is there a way please, to do it through system tables  using a stored procedure which allows to modify data type in the table and in other object where the concerned fields/tables are referenced ?