Create new database in SQL Server 2012

Right click the Database node and choose New Database.

z01

You see New Database window:

z02

In Database name field write test.

z03

Click the Options tab.

z04

In Recovery model choose from list Full. Click the OK button.

z05

Click the Filegroups tab and the OK button.

z06

You see test database on the list of databases.

z07

Right click the Tables node and choose New Table.

z08

First column named id and set data type as integer. Uncheced Allows Null field. Select this row. In Column Properties list Identity Specification and select Is Identity as Yes. It is autoincrement for primary key.

z09

Right click the arrow next to id field and select Primary Key. You see icon of key in first row.

z10

In second row definite column named name of varchar(50) data type.

z11

Close this file. The Choose Name window appear. z12

Change name for mytest. Click the OK button.

z13

z14

In Tables node of  test database you see new table.

z15

Right click the node mytest and select Edit. Write several names in name field. Id field will be added automatic.

z16

When you select data you all data from mytest table.

z17