arkuznetsov/SQL_change_logical_file name.sql

Last active May 28, 2019 11:03

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/arkuznetsov/4c1e70339544bbfa9ff943cae3a6b3f4.js"></script>
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