| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TABLE_NAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 2 | COLUMN_NAME | Column Name / Header | nvarchar | 60 | 0 | CHAR | (N' ') | No | | COLUMNNAME | Allow NULL? |
| 3 | KEYFLAG | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 4 | HAS_INDEX | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 5 | RECORD_COUNT | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 6 | VARIABLE_SIZE | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 7 | FIXED_SIZE | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 8 | EST_MS_TOTAL | Decimal number, 20 digits, none after decimal point | decimal | 20 | 0 | DEC | ((0)) | Yes | | DEC20 | |
| 9 | TYPEKIND | Category of Dictionary Type | char | 1 | 0 | CHAR | (N' ') | Yes | | TYPEKIND | Allow NULL? |
| 10 | SIZE_IN_BYTE | | decimal | 16 | 0 | | ((0)) | Yes | | | |
| 11 | LOB_SIZE_IN_BYTE | | decimal | 16 | 0 | | ((0)) | Yes | | | |
