SQL Server Create statement

1.CONTAINMENT

SQL Server 2012 new feature, the default value is off. (not detailed in the book too).

2.ON

On for two places, the first is the location of the file where the data is stored, and the second is the location of the file where the log is stored. On the back of the primary concept: want to store all the content in a file.

3.NAME

A logical name that SQL Server uses internally to reference the file. You need to use this name when you need to modify the database size

4.FILENAME

The actual operating system files in the disk name, if not written by default, are placed in the folder where SQL Server is installed, the default database file is the. mdf suffix, and the log is an. ldf file.

5.SIZE

The database size, if not written, is the same size created by the graphic.

6.MAXSIZE

The maximum size allowed for the database.

7.FILEGROWTH

Provides a value that describes how many bytes or percentages of files are incremented each time.

8.LOG on

The Log on option allows you to specify which files require logs and where they are located.

9.COLLATE

This option handles sorting, letter size, and whether accent sensitivity is an issue.

SQL Server Create statement