After deploying the SAP HANA Container, the ra_get_table_columns command shows what column properties are obtained by the container when table metadata is obtained from the database. SAP HANA Container gets the table column information during model deployment so that tables do not need to be added to the model for this command to work.
ra_get_table_columns <modelName>, <tableName>
Run the ra_get_table_columns command on the "jmt" model and the "ALL_DATATYPES" table:
ra_get_table_columns jmt, ALL_DATATYPES go
POSITION NAME TYPE TYPE NAME SIZE PRECISION ---------- ---------------- ---------- ------------ ---------- ---------- 1 COL_ID 4 INTEGER 10 10 2 COL_DATE 91 DATE 10 10 3 COL_TIME 92 TIME 8 8 4 COL_TIMESTAMP 93 TIMESTAMP 27 27 5 COL_TINYINT -6 TINYINT 3 3 6 COL_SMALLINT 5 SMALLINT 5 5 7 COL_INTEGER 4 INTEGER 10 10 8 COL_BIGINT -5 BIGINT 19 19 9 COL_DECIMAL 3 DECIMAL 34 34 10 COL_REAL 7 REAL 7 7 11 COL_DOUBLE 8 DOUBLE 15 15 12 COL_CHAR 1 CHAR 10 10 13 COL_VARCHAR 12 VARCHAR 20 20 14 COL_SECONDDATE 93 SECONDDATE 19 19 15 COL_SMALLDECIMAL 3000 SMALLDECIMAL 16 16 16 COL_NCHAR -8 NCHAR 10 10 17 COL_NVARCHAR -9 NVARCHAR 10 10 18 COL_ALPHANUM -9 ALPHANUM 1 1 19 COL_VARBINARY -3 VARBINARY 10 10 20 COL_BLOB -4 BLOB 2147483647 2147483647 21 COL_CLOB -1 CLOB 2147483647 2147483647 22 COL_NCLOB -10 NCLOB 2147483647 2147483647 SCALE PRIMARY KEY NULLABLE SEARCHABLE LOB ---------- ----------- ---------- ---------- ---- 0 Y NOT NULL Y 0 NULL Y 0 NULL Y 7 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y 0 NULL Y