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

Revisions

  1. arkuznetsov renamed this gist May 28, 2019. 1 changed file with 0 additions and 0 deletions.
    0 SQL change logical file name → SQL_change_logical_file name.sql
    View file
    File renamed without changes.
  2. arkuznetsov revised this gist May 28, 2019. No changes.
  3. arkuznetsov created this gist May 28, 2019.
    3 changes: 3 additions & 0 deletions SQL change logical file name
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    USE [master]
    ALTER DATABASE [MyDatabase] MODIFY FILE (NAME = N'CurrentLogicalFileName', NEWNAME = N'NewLogicalFileName')
    go