This stored procedure helps automatically create new partition on a new file group to an already partitioned table. I have tested the script in my…