To create a database using query analyzer in Microsoft SQL server. We can use “CREATE” statement.
Syntax:
CREATE DATABASE Database_Name
How to verify:
You can check it in the list of databases with the following SQL Command.
SHOW DATABASES
OR
Newly created database will be populate into database dropdown list in SQL Server
Important Notes:
Logged in user should have proper privileges/permission to create database into SQL Server. If you are getting error message while creating new database, you can contact you SQL Server administrator/provider.