Rename database in sql 2008



Rename Database in sql server 2008

1.       How to create database in sql server 2008

USE Master;
Go

CREATE DATABASE SALARYMANAGEM;
Go

2.       How  to rename database

ALTER DATABSE SALARYMANAGEM
MODIFY NAME=SALAYMANAGEMANT;
Go
3.       How  to drop database

Drop Database SALAYMANAGEMANT;
Go

Deepak Goyal