The logical name of a database file went out sync after running following statement.
ALTER DATABASE UserDataBase MODIFY FILE (NAME = 'FileNameOld', NEWNAME = 'FileNameNew')
It updated the name column of sys.master_files table correctly to "FileNameNew" but the name column of sys.Database_files table remained as "FileNameOld".
Does anyone know the cause of it and how to fix the problem? Thanks in advance.