I have a very big database, each table have id column is big int (very long). Now my project is change and i have make it shorter, so to do it i need new func to create new id column as well as reset fk_key for all of them.
Can i create a loop to search all table use big-int id and in side of it i change a value and change fk as well.