PROPERTY Table Row Storage Size
Table - Sorted Table - Copybook - Create Table - Format File - Bulk Insert - Row Size - Back To Table Index

Column NameData TypeBytes Used
PROPERX_KEY BIGINT8
PROPERX_GRPCD TINYINT9
PROPERX_DISTRICT TINYINT10
LOTTYPE_TYPE_LOT TINYINT11
LOTTYPE_WET_LOT VARCHAR(1)12
LOTTYPE_SITE_VALUE INT16
PROPERTYPE VARCHAR(1)17
PROPER_NBR VARCHAR(2)19
PROPER_CODE1 TINYINT20
PROPER_AMOUNT SMALLINT22
PROPER_CODE2 TINYINT23
PROPER_PERCENT2 DECIMAL(4,2)27
PROPER_VALUE INT31
PROPERX_ZONE VARCHAR(4)35
PROPER_AGRI_CODE VARCHAR(1)36
PROPER_AGRI_YEAR SMALLINT38
PROPER_EXCESS_FLAG VARCHAR(1)39
PROPER_EFF_YEAR SMALLINT41
PROPER_REAPPRAISAL1 SMALLINT43
PROPER_REAPPRAISAL2 SMALLINT45
PROPER_INSPECT_CODE TINYINT46

21 columns are defined.

To Top - Print

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