Script to Rename Database
CREATE DATABASE sqld1
–Solution - I
EXEC Sp_renamedb ‘SQLDB1’, ‘ram’
–Solution - II
ALTER DATABASE sqldb1 MODIFY name=ram
CREATE DATABASE sqld1
–Solution - I
EXEC Sp_renamedb ‘SQLDB1’, ‘ram’
–Solution - II
ALTER DATABASE sqldb1 MODIFY name=ram
No comments:
Post a Comment