Sunday 22 August 2021

Create database in SQL server

 Hi guys , in this blog post we will see how to create database in SQL server. This post is for SQL server beginners.

Please follow below steps:-

1)Go to start menu and search for SSMS(SQL server management studio) and click on SSMS.

Create database in SQL server

2)Login into SQL server. Select server name then enter username and password. Click on connect button.

Create database in SQL server

3) Go to object explorer. Right click on database and select new database.

Create database in SQL server

4)Enter database name, then select owner of database.

Create database in SQL server

5) You can also change database file names and autogrowth options of database. Then click on ok button.

Create database in SQL server

6) Wait for sometime. Within few seconds your SQL server database will be created, as show in below screenshot.

Create database in SQL server

Create database in SQL server


In this way, we can create database in SQL server.









No comments:

Post a Comment