Database Reference
In-Depth Information
Then click New Query, and you should see a window like in Figure 3-4.
Figure 3-4.
SQL Server Management Studio: New Query pane
SSMS has a new look and feel in the release of SQL Server 2012; actually, Microsoft has utilized the
Visual Studio IDE for SQL Server 2012, so if you have used Visual Studio 2010 before, you will find it
similar. If you have not worked with Visual Studio 2010 yet, then you will see the UIs are similar when we
start coding for C# using Visual Studio 2012 later in the topic.
To create a database in simple way, follow these steps:
1.
Make sure your New Query pane shows the master database just below the
Save icon on the toolbar.
2.
Go to the query pane, and to make sure you are in the master database, type
the following:
use master
3.
Select the statement, and click Execute or press F5; you should see the
message “Command(s) completed successfully.”
4.
Now press Enter to add a new line, and type the following:
create database MySQLDb
