How To Create A SQL Server Database using SSMS? (3 different ways)

Published: 07 November 2023
on channel: Expert Only Tutorials
91
3

Step by step tutorial on How To Create A SQL Server Database using SSMS using 3 different ways:

0:12 Start by opening SSMS

0:20 1. Using the GUI
The video begins with a clear, step-by-step demonstration of creating a database using the SQL Server Management Studio (SSMS) graphical user interface. The screen zooms in on the crucial steps, such as opening SSMS, navigating to the 'Databases' section, and showing the right-click context menu. The creator walks through filling out the 'New Database' form, showing the audience exactly what to type and select, making the process feel intuitive.

0:54 2. With the Generate Scripts Option :
The second method covered is the 'Generate Scripts' feature. The video details how to access this feature from the SSMS Object Explorer by right-clicking on an existing database. It describes selecting the appropriate scripting options and output type. Viewers see a clear list of actions and decisions as they follow the cursor, and on-screen annotations highlight the simplicity of exporting a template script from one database to create another.

1:58 3. Using a Simple CREATE DATABASE Statement
Lastly, the video presents the simplicity of writing a T-SQL statement. The presenter types out the CREATE DATABASE command in a new query window, showcasing how just a few lines of code can establish a new database. This segment reinforces how direct and uncomplicated the process is, with each part of the command explained concisely for clarity.


On this page of the site you can watch the video online How To Create A SQL Server Database using SSMS? (3 different ways) with a duration of hours minute second in good quality, which was uploaded by the user Expert Only Tutorials 07 November 2023, share the link with friends and acquaintances, this video has already been watched 91 times on youtube and it was liked by 3 viewers. Enjoy your viewing!