Creating Database and Tables - Beginning C# 5.0 Databases - page 28

5. In this example, we are creating a new database named MySQLDb. Remember,
SQL Server is not case-sensitive, so no matter how you type your SQL
statements, they will work just fine.
6. After typing the create statement, select this newly added create statement,
and press Execute or F5. When you look at the list of databases under the
Databases folder in Object Explorer, you should see the MySQLDb database
you just created, as shown in Figure 3-5.
Figure 3-5. Creating a SQL Server database in a simple way
This newly created database will be no different from any other databases in that it will consist of
.mdf and .ldf files. By using this one-liner SQL statement…
Create Database database-name
you have given control to SQL Server to create the files with its own predefined settings on your
behalf. But this approach has limitations and restrictions:
• It stores data and log files on the same disk under Program Files\Microsoft SQL
Server; what if you want to separate the log file from the data files and put one on
another disk or in another folder?