ALTER TABLE uyumsoft.invd_quality ALTER COLUMN quality_code TYPE varchar(500) USING quality_code::varchar;
ALTER TABLE uyumsoft.invd_quality ALTER COLUMN description TYPE varchar(500) USING description::varchar;

SELECT dba.deps_save_and_drop_dependencies('uyumsoft','invd_quality');

SELECT * FROM dba.deps_saved_ddl

SELECT dba.deps_restore_dependencies('uyumsoft','invd_quality');;