HANA - Data Type

Scalar Data Types

The SQLScript type system is based on the SQL-92 type system. It supports the following primitive data types:

• Numeric types: TINYINT SMALLINT INT BIGINT DECIMAL SMALLDECIMAL REAL DOUBLE
• Character String Types: VARCHAR NVARCHAR ALPHANUM
• Date-Time Types TIMESTAMP SECONDDATE DATE TIME
• Binary Types: VARBINARY
• Large Object Types: CLOB NCLOB BLOB
• Spatial Types: ST_GEOMETRY

SAP HANA SQL and System Views Reference

Table Types: Tabular Result

See CREATE TYPE

CREATE TYPE tt_publishers AS TABLE (
   publisher INTEGER,
   name VARCHAR(50),
   price DECIMAL,
   cnt INTEGER);

You create a table type called tt_years.

CREATE TYPE tt_years AS TABLE (
   year VARCHAR(4),
   price DECIMAL,
   cnt INTEGER);

DROP TYPE my_type;