Creating a database in SQL Server is a straightforward process. You can create a database using SQL Server Management Studio (SSMS) or by executing a T-SQL command. Below are the steps and examples for both methods.
Creating a Database Using SQL Server
Management Studio (SSMS)
Open SSMS:
Open SQL Server Management Studio and connect
to your SQL Server instance.
Create Database:
In Object Explorer, right-click on the "Databases" node and select "New Database...".
In the "New
Database" dialog box, enter the name of the database
(e.g., mydatabase).
Configure any additional options as needed
(e.g., file locations, initial sizes, etc.).
Click "OK" to create the database.
Creating a Database Using T-SQL
To create a database using
T-SQL, you can execute the following command:
CREATE DATABASE mydatabase;