Sequences Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

This editor lets you view creation properties for a sequence as well as modify the scope, starting value and increment value.

To edit a sequence:

  1. Open an editor on the sequence. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you view the Schema, Name, Create Date, Data Type Schema, Base Data Type, Data Type Name, and Data Type Precision properties for the synonym. Lets you modify the Start With, Increment By, Minimum Value, Maximum Value, Cycle, Cache, and Cache Size properties. For more information on these properties, see Sequences (SQL Server) - Properties. This tab also includes the following, display-only properties: Current Value - The value most recently returned by the NEXT VALUE FOR function or the last value resulting from an sp_sequence_get_range procedure execution. Is Exhausted - Indicates that the sequence object has reached the Maximum Value and Cycle is not set. The NEXT VALUE FOR function will return an error until the sequence is restarted using ALTER SEQUENCE.


For details on using this tab, see Working with Object Dependencies.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.