public static string GetRestartSql(Table t)
{
string statementName = t.GetColumn(t.IdentityColumn).GetName().StatementName;
NumberSequence identitySequence = t.IdentitySequence;
StringBuilder builder1 = new StringBuilder(0x80);
builder1.Append("ALTER").Append(' ').Append("TABLE");
builder1.Append(' ').Append(t.GetName().GetSchemaQualifiedStatementName());
builder1.Append(' ').Append("ALTER").Append(' ');
builder1.Append("COLUMN");
builder1.Append(' ').Append(statementName);
builder1.Append(' ').Append("RESTART");
builder1.Append(' ').Append("WITH").Append(' ').Append(identitySequence.Peek());
return(builder1.ToString());
}
public void Reset(NumberSequence other)
{
lock (this)
{
this._name = other._name;
this._startValue = other._startValue;
this._currValue = other._currValue;
this._lastValue = other._lastValue;
this._increment = other._increment;
this._dataType = other._dataType;
this._minValue = other._minValue;
this._maxValue = other._maxValue;
this._isCycle = other._isCycle;
this._isAlways = other._isAlways;
}
}
