Thursday 6 March 2014

Script to Rename Database


CREATE DATABASE sqld1
–Solution - I
EXEC Sp_renamedb  ‘SQLDB1’,  ‘ram’

–Solution - II
ALTER DATABASE sqldb1 MODIFY name=ram

No comments:

Post a Comment