Auto increment primary key in SQL tables

Question

Using the Sql Express Management Studio 2008 GUI (not with encoding), how to make a primary key with auto-increment?

Let me explain: there is a table in which there is a column called "id", and the elements of this column are primary. I want this column to grow automatically, but how?

Greetings

Answer 1

• Presumably you are in a table design. If not: right-click on the table name - Design .
• Select the desired column.
• In the " Column Properties " (bottom), highlight the " Identifier Specification " section, expand it, then switch " (Is Identity) " to " Yes ."

Answer 2

Right click on the table in SSMS, "Design" and click on the id column. In the properties, specify the identifier for sowing @, for example. 1 and have an increment of 1 - save, and you're done.

Answer 3

Although this cannot be done in the GUI, you can get auto-increment simply by using the IDENTITY (start, increment) data type:

CREATE TABLE "dbo"."TableName" ( id int IDENTITY(1,1) PRIMARY KEY NOT NULL, name varchar(20), ); 

the insert statement should display all columns except the id column (it will be populated using a value with auto-increments):

 INSERT INTO "dbo"."TableName" (name) VALUES ('alpha'); INSERT INTO "dbo"."TableName" (name) VALUES ('beta'); 

and result

 SELECT id, name FROM "dbo"."TableName"; 

will be

 id name -------------------------- 1 alpha 2 beta 

Answer 4

I do not have Express Management Studio on this computer, so I'm going to be based on memory. I think you need to set the column as "IDENTIFICATION", and there should be [+] in the properties where you can expand, and set auto-increment to true.

Answer 5

for those who have a problem with this, still does not allow you to save, as soon as it is changed in accordance with the answer below, follow these steps:

tools -> options -> designer -> Table and database designers -> uncheck "prevent the saving of changes requiring a table restore" → OK

and try to save, as it should work now

Answer 6

I think there is a way to do this at the stage of determining how it

create a table employee (id int identity, varchar name (50), primary key (id)) .. I am trying to see if there is a way to modify an existing table and make the column as Identity, which does not look theoretically (as existing values ​​may need to be changed)