HANA - Data Type

About

Type in HANA

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;

Powered by ComboStrap