Sequences Wizard (SQL Server)

Go Up to Microsoft SQL Server Object Wizards

This wizard builds and submits a CREATE SEQUENCE statement.

To create a new full-text catalog using a wizard:

1. Open a creation wizard for a sequence. For details, see Opening an Object Wizard.
2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
   • Properties panel - for details, see Full-text Catalogs (SQL Server) - Properties.
   • DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
3. Finally, use the Execute button to create the object.

Sequences (SQL Server) - Properties

When creating or editing a sequence, this tab/panel lets you work with the following settings:

Setting	Description
Schema and Name	Lets you provide identification for the sequence.
Start With	Lets you provide a START WITH argument value, specifying the first value to be returned by the sequence.
Increment By	Lets you provide an INCREMENT BY argument value, specifying the value by which to increment (or decrement if negative) the sequence object for each call to the NEXT VALUE FOR function.
Minimum Value and Maximum Value	Lets you provide MINVALUE and MAXVALUE argument values, specifying the bounds for this sequence.
Cycle	If selected, a CYCLE argument is generated, specifying that sequence values should restart from the minimum value (or maximum for descending sequences) or throw an exception when the minimum/maximum value is exceeded. If unselected, the default NO CYCLE is assumed.
Cache and Cache Size	If Cache is unselected, a NO CACHE argument is generated. If Cache is selected, a CACHE argument is generated. A CACHE argument value can be provided using the Cache Size control, and if no Cache Size value is provided, SQL Server will generate a value.
Data Type Schema, Data Type Name, and Data Type Precision	These controls let you build an AS argument, specifying datatype details for the new sequence. If no values are selected/provided, SQL Server will, by default, generate a sequence object of type BIGINT. After selecting a Data Type Schema, the Data Type Name dropdown is populated with user datatypes created from a base datatype of BIGINT, TINYINT, SMALLINT, INT, BIGINT, DECIMAL, or NUMERIC. Data Type Precision is a read-only field displaying the precision of the selected user datatype. NOTE: You can use system types if you select a Data Type Schema of SYS.

After creation, the Sequences Editor lets you view the current value of the sequence and whether the maximum value has been exceeded. For details. see Sequences Editor (SQL Server).