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
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;