Subject Skipped internal numbers for rdb$relation_fields.rdb$field_position
Author Venus Software Operations
Hi all

I noticed that there are skipped numbers for the series for a given
table fields in the rdb$relation_fields.rdb$field_position

How can I get the corresponding visual field numbers? So even though a
table fields look the same in both the databases but internally the
development version has skipped numbers whereas not in the production
database. As I am trying to update a database remotely using script,
these missing numbers are flagging false positives.

Currently I can hack the system tables and force the numbers as on the
dev. copy but I was hoping to detect field order changes if ever done on
the dev. copy and the same reorder to do on the prod. copy using
standard SQL command of ALTER TABLE aaa ALTER bbb POSITION 999

I hope I was able to convey my thoughts. Please advise.

Thanks and regards