Novice Techie

How to Create MS SQL Server Database Using Microsoft SQL Server Management Studio and T-SQL?

This article explains How to create a database in Microsoft SQL Server using the MS SQL SERVER Management Studio and T-SQL. This article explains the step by step method to create the database using the Management Studio, beginners in MSSQL can easily create the database using this tutorial.

1. Open Microsoft SQL Server Management Studio.
2. Connect to the database engine using database administrator credentials.
3. Expand the server node.
4. Right click Databases and select New Database.
5. Enter a database name
6. Add / Change Data file path
7. Add / Change Log file path
8. Click OK to create the database.

Create database SQL syntax for MS SQL Server is as follows.