Sequence Generators

Sequence generators are used to generate values that are unique across multiple tables, and to generate default values that are something other than the set of natural numbers (1, 2, 3...).

• Creating a Sequence Generator
  Create a sequence generator on a specified resource.
• Deleting a Sequence Generator
  Delete one or more sequence generators.
• Restarting a Sequence at Start Value
  Restart the sequence generator at the start value defined.
• Generating Sequence Generator DDL Command
  Generate data description language for one or more sequence generators. The DDL code can be a useful reference and training tool.
• Viewing or Modifying Sequence Generator Properties
  View or change the properties of a sequence generator.
• Granting Sequence Generator USAGE Permission
  Grant sequence generator usage permission to users and roles.
• Revoking Sequence Generator USAGE Permission
  Remove sequence generator usage permission from users and roles.
• Sequence Generator Privilege Summary
  A list of the system privileges and object permissions required to complete the various sequence generator tasks.