Rename DB Files

posted in: Tech | 0

 

To rename the logical file name of the pubs data file to pubs_data.

ALTER DATABASE pubs
MODIFY FILE (NAME = pubs, NEWNAME = pubs_data)