USE [database_test] GO --创建SEQUENCE CREATE SEQUENCE defaultSequence AS INT --设置开始行 START WITH 1 --自增量 INCREMENT BY 1 --删除SEQUENCE DROP SEQUENCE [DefaultSequence] --修改SEQUENCE ALTER SEQUENCE defaultSequence --自增量 INCREMENT BY 3 SELECT NEXT VALUE FOR [DefaultSequence] GO
原文：http://www.cnblogs.com/xyzhuzhou/p/5012378.html