Creating, altering and dropping a database - Part 2

To create the database graphically

1. Right Click on Databases folder in the Object explorer

2. Select New Database

3. In the New Database dialog box, enter the Database name and click OK.



To Create the database using a query

Create database DatabaseName



To alter a database, once it's created

Alter database DatabaseName Modify Name = NewDatabaseName




To Delete or Drop a database

Drop Database DatabaseThatYouWantToDrop