LAND Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Row Size - Back To Table Index

Column NameData TypeBytes Used
PROPERX_KEY BIGINT8
PROPERX_GRPCD BYTEINT10
PROPERX_DISTRICT BYTEINT12
LOTTYPE_TYPE_LOT BYTEINT14
LOTTYPE_WET_LOT CHAR(1)15
LOTTYPE_SITE_VALUE INTEGER19
PROPERTYPE CHAR(1)20
PROPER_NBR CHAR(2)22
O_UNPACKED VARCHAR(30)52
PROPER_CODE1 BYTEINT54
PROPER_AMOUNT1 SMALLINT56
PROPER_CODE2 BYTEINT58
PROPER_PERCENT2 DECIMAL(4,2)62
PROPER_VALUE INTEGER66
PROPERX_ZONE CHAR(4)70
PROPER_AGRI_CODE CHAR(1)71
PROPER_AGRI_YEAR SMALLINT73
PROPER_EXCESS_FLAG CHAR(1)74
PROPER_EFF_YEAR SMALLINT76
PROPER_REAPPRAISAL INTEGER80

20 columns are defined.

To Top - Print

Output Generated By +1DataElements From +1 Software Engineering LLC.
Created on: 23-MAY-2020 10:29 AM