Skip to content

Instantly share code, notes, and snippets.

@arkuznetsov

arkuznetsov/SQL_change_logical_file name.sql

Last active May 28, 2019 11:03
Show Gist options
  • Save arkuznetsov/4c1e70339544bbfa9ff943cae3a6b3f4 to your computer and use it in GitHub Desktop.
Save arkuznetsov/4c1e70339544bbfa9ff943cae3a6b3f4 to your computer and use it in GitHub Desktop.
Download ZIP
SQL change logical file name
Raw
SQL_change_logical_file name.sql
USE [master]
ALTER DATABASE [MyDatabase] MODIFY FILE (NAME = N'CurrentLogicalFileName', NEWNAME = N'NewLogicalFileName')
go
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment