How to create and delete sql database?

If we want to create a new database in sql server first of all we have to open (connect) our sql server management studio. After connecting sql server management studio we have to  go our new query editor window where we can code everything.

1. First way (using code)

We have to right the code below for creating sql database:

-- sql have already a Master Database , we should use it to create new database
-- -- Double dash sign use for comment any code
use master
create database MyDB
go
-- go use for closing an expression

If we want delete our database the code is look like:

-- in sql drop command use for delete database or table permanently
drop database MyDB
go

2. Second Way  (using design mode)

Step-1: Right click to Database > click New Database

Step-2: In new window, write database name and press OK button.

Step-3: Almost done

* Delete Database: Just right click the database (MyDB) and Delete.