VERSION 10 DOCUMENTATION IS IN PROGRESS. PLEASE VIEW V9 ARTICLES WHILE V10 ARTICLES ARE BEING PUBLISHED.

Alter ID Sequences

Prev Next

Overview 

The sequences of objects like Case Entities can be reset or made to start with a different number.


Query Editor

Inside the query editor add in this SQL code:

SELECT
  name,
  cast(start_value AS NUMERIC)   AS start_value,
  cast(increment AS NUMERIC)     AS increment,
  cast(current_value AS NUMERIC) AS current_value
FROM sys.sequences;
ALTER SEQUENCE c_sequence RESTART WITH 1;