You can change the Drawing Number from the contextual menu.
\
If the numbering is done using the Drawing Number option:
The renumbered drawing in the example was: [SP] Pos pa1009 Sheet 1009.dwg
It was renumbered from 1009 to 1100 and the detail went into the Update category as: [SP] Pos pa1009 Sheet 1100.dwg
After running the Update labels command, the detail name changed automatically to: [SP] Pos pa1100 Sheet 1100.dwg
If you modify a file name using the Rename drawing command and then you renumber it using the Rename drawing number command, a warning message will appear stating that the "…new drawing number will not get updated in the file name". The detail drawing will enter the Update labels category.
If you update, the SP or MP number of the part will be updated inside the drawing and the file name will not change. Please see the images below: