Calculating record size of a table

17 views
Skip to first unread message

Brahim Mohamed

unread,
Jan 9, 2021, 11:48:00 AM1/9/21
to firebird-support
Hello,

Please, is there a way to calcutate record size of a table using systems table in a SP ?
Thanks

Dimitry Sibiryakov

unread,
Jan 9, 2021, 11:51:13 AM1/9/21
to firebird...@googlegroups.com
09.01.2021 17:47, Brahim Mohamed wrote:
> is there a way to calcutate record size of a table using systems table in a SP ?

Yes, you can sum lengths of each fields from table rdb$relation_fields which is
described in Language Reference. But the result is completely pointless because record
size has very little corelation with storage size.

--
WBR, SD.

Brahim Mohamed

unread,
Jan 9, 2021, 12:08:19 PM1/9/21
to firebird-support
I will see the  Language Reference   Thanks
Reply all
Reply to author
Forward
0 new messages