Change Database Name in SQL Server

Posted on: Fri Jun 27 16:28:38 -0700 2008. Updated on: Fri Jun 27 16:28:38 -0700 2008.
Category: SQL Server 2005

Very easy to change a database name in sql server, but it must be done via a sql command

 —-Create db for test
CREATE DATABASE Test
GO
    —-Rename the Database Test
ALTER DATABASE Test MODIFY NAME = "New Test"
GO

Comments:

Add a Comment:

simple_captcha.jpg
(human authentication)


Ads

Categories


About

Random foliage

This website is meant to be a reference for ASP Dot Net developers. The entries are a compilation of things I've figured out how to do and that I deem useful to keep of track for future reference. Assumptions: web development with: C Sharp (vb sucks), visual studio 05/08, .net 3.5, meant for programmers. Written by: James Reategui.