Subject | reorganise id's |
---|---|
Author | martinknappe |
Post date | 2006-05-15T13:36:06Z |
hello
i'm pretty new to firebird and i find the documentation a bit
overwhelming so please don't be bothered if i'm asking a question i
wouldn't have to ask if i'd rtfm
if you create a database with different tables and an integer primary
key for every table, you can't be helped but get a database with ever
more gaps in between these primary keys as you insert new records and
delete old ones, right? now, is there a way to reorganise such a gappy
database, i.e., a way to have the database "recreated" with the same
data but with all entries after such gaps being placed?
thanx,
martin
i'm pretty new to firebird and i find the documentation a bit
overwhelming so please don't be bothered if i'm asking a question i
wouldn't have to ask if i'd rtfm
if you create a database with different tables and an integer primary
key for every table, you can't be helped but get a database with ever
more gaps in between these primary keys as you insert new records and
delete old ones, right? now, is there a way to reorganise such a gappy
database, i.e., a way to have the database "recreated" with the same
data but with all entries after such gaps being placed?
thanx,
martin