Create new database in SQL Server 2012

Right click the Database node and choose New Database.

You see New Database window:

In Database name field write test.

Click the Options tab.

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

Click the Filegroups tab and the OK button.

You see test database on the list of databases.

Right click the Tables node and choose New Table.

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.

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

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

Close this file. The Choose Name window appear.

Change name for mytest. Click the OK button.

In Tables node of  test database you see new table.

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

When you select data you all data from mytest table.