SQL Server offers two options to Create New Database: Running a SQL command in the SQL Server Management Studio (SSMS) query window or
Manually creating a database using the SSMS interface.
The following steps outline the process of creating a database:
Create New Database Using SQL COMMAND
To create a database using a SQL query, use the following syntax:
Replace “databasename” with the desired name for your database. This query will create a new database with the specified name. Note that the semicolon (;) is required to end the statement.
SQL Query Syntax : CREATE DATABASE databasename;
Here, If your Database name is “University” then please type below SQL command Syntax:
SQL Query Syntax : CREATE DATABASE University;
Create New Database Using SSMS Interface
Step1: Open your SQL Server Management Studio
Step2: Below Object Explorer Click Connect to Server
- If you are using Windows Authentication then you don’t need to provide password
- If you are using Server Authentication Provide Server Information ( Like : Server Name, Authentication, UserName and Password) [Note: SQL server Default User : sa]
Step3: After Successfully login to server Right Click on Databases Select New Database….
then put your Database name on the text field
After Click OK Button you see your Database “University” has been created successfully.
