Datenbanken-Tipp: Lücken in IDs finden

[Jelly]

Ergänzend hier mal die Syntax für 3 unterschiedliche DBMS:

MySQL (ab Version 4.1)

SQL-Code:

SELECT (Id+1) AS FreieId FROM Tabelle 
WHERE (Id+1) NOT IN (SELECT Id FROM Tabelle) 
ORDER BY FreieId
limit 1

Firebird

SQL-Code:

SELECT First 1 (Id+1) AS FreieId FROM Tabelle 
WHERE (Id+1) NOT IN (SELECT Id FROM Tabelle) 
ORDER BY Id+1

MSSQL

SQL-Code:

SELECT TOP 1 (Id+1) AS FreieId FROM Tabelle 
WHERE (Id+1) NOT IN (SELECT Id FROM Tabelle) 
ORDER BY Id+1