declare @dbo varchar(50) set @dbo = 'Dbo.seq_' declare @tableID varchar(10) set @tableID = 'SOMETABLEID' declare @sql varchar(500) set @sql = 'alter sequence' +@dbo+@tableID + 'minvalue' +CAST(YOURRECIDValue as bigint) +'restart with' +CAST(YOURRECIDValue as bigint) exec (@sql)
public static int64 alterRecId(TableId _tableId, int64 _maxRecId) { //Run SQL to alter seq id //alter sequence dbo.seq_7051 minvalue alterRecId restart with alterRecId int64 alterRecId = _maxRecId+1; const str sqlStatementText = "declare @dbo varchar(50) set @dbo = 'Dbo.seq_' declare @tableID varchar(10) set @tableID = @SelectedTableId declare @sql varchar(500) set @sql = 'alter sequence ' +@dbo+@tableID + 'minvalue ' + @AlterRecId + 'restart with' + @AlterRecId exec (@sql)"; var connection = new Connection(); Statement statement = connection.createStatement(); Map paramMap = SqlParams::create(); paramMap.add('SelectedTableId', _tableId); paramMap.add('AlterRecId', alterRecId); var results= statement.executeQueryWithParameters(sqlStatementText, paramMap); results.next(); str result1 = results.getString(1); alterRecId = str2Int64(result1); statement.close(); return alterRecId; }
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 683 Most Valuable Professional
André Arnaud de Cal... 563 Super User 2025 Season 2
Sohaib Cheema 398 User Group Leader
