SAP HANA创建类型(SAP HANA CREATE TYPE):
语法：CREATE TYPE {schema.}name AS TABLE (name1 type1 {, name2 type2,...})
实列1：
CREATE TYPE tt_publishers AS TABLE (
publisherINTEGER,
nameVARCHAR(50),
price DECIMAL,
cntINTEGER
);
实列2：
CREATE typett_year AS TABLE(
year varchar(4),
price decimal,
cnt integer
);
删除类型：
语法：DROP TYPE {schema.}name {CASCADE}
页:
[1]