Microsoft SQL Server 2008 R2的索引自动增量 [英] Index autoincrement for Microsoft SQL Server 2008 R2

问题描述

我在SQL Server 2008 R2中创建了一个新表，我希望索引是自动递增的. 怎么做?没有身份数据类型；我选择了诠释

I created a new table in SQL Server 2008 R2, and i would like that the index is on autoincrement. How to do that? There is no identity data type; i selected int

推荐答案

在SQL Server中，它不是单独的数据类型(自动增量")-但您可以将INT列定义为IDENTITY.

In SQL Server, it's not a separate datatype ("autoincrement") - but you can define an INT column to be an IDENTITY.

如何创建表-可视设计器或T-SQL脚本?

How are you creating your table - visual designer or T-SQL script??

在T-SQL中，您将使用:

In T-SQL, you would use:

CREATE TABLE dbo.MyTable(ID INT IDENTITY(1,1) ......

在可视表设计器中，您需要检查:

and in the visual table designer, you need to check:

这是INT类型的列的选项-您可以定义种子(起始值)和增量-通常都设置为1.

It's an option for a column of type INT - you can define the seed (starting value) and the increment - typically both are set to 1.

这篇关于Microsoft SQL Server 2008 R2的索引自动增量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！