Online Documentation for SQL Administrator for SQL Server

Properties


Use the Properties tab of Synonym Editor to create/edit a synonym and specify its properties.

 

Name

Specify the name of the sequence to be created, or view the name of the sequence being edited. Note that the sequence name must be unique within its schema.

 

Schema

Use the drop-down list to select the schema in which the sequence is created.

 

Sequence Editor - Properties

 

 

For data type

Select whether to create a sequence for the !RadioButton System type or the !RadioButton User-defined type.

 

Type

Specify the type of generated sequence numbers.

 

Precision

Specify the size value (for the decimal type).

 

Next value

Specify the first sequence number to be generated. Use this setting to start an ascending sequence at a value greater than its minimum or to start a descending sequence at a value less than its maximum.

 

Increment

Specify which value is added to the current sequence value to create a new value. A positive value will make an ascending sequence, a negative one - a descending sequence. The default value is 1.

 

Minimum value

Specify the minimum value of the sequence.

 

Maximum value

Specify the maximum value for the sequence.

 

Cache

Specify how many sequence numbers are to be preallocated and stored in memory for faster access in the !RadioButton This field or select !RadioButton Default or !RadioButton None.

 

!CheckBox Cyclic

This option indicates that the sequence continues to generate values after reaching either its maximum or minimum value. After an ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum value.