通过SQL在SQL SERVER里修改数据库名

在查询分析器里执行

sp_rename ‘数据库原来的名字’,’数据库新名’,’database’

比如原来你的数据库是db1 你想修改为db2则语句为

sp_rename ‘db1′,’db2′,’database’

Leave a Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.