Question: I want to set a **tinyint** field as autoincrement, but table constructor dont let me do it. But he lets to **int** and **bigint** types. Whats the problem?

Here is the screenshot: <http://gyazo.com/ce8d345ee94bf26e833fe16133b5eee5.png>

The first row "Идентификация" is an **Identity** field in English.

Answer: 
SQL Server Compact only support int and bigint with IDENTITY
First of all, why do you use TinyInt? TinyInt has a range from -128 to +127, so is is not very well suited for auto\_increment columns.