HANA Tips and Tricks

HANA Database statement Syntax

/*** Truncate Statement Syntax ****/

TRUNCATE TABLE “KN227869”.“T_TABLE”;

/***Create & Drop Table Type***/

CREATE TYPE CAL_VIEW AS TABLE (YEAR VARCHAR(15), QTR VARCHAR(15), MONTH VARCHAR(15), SKEY VARCHAR(15));

DROP TYPE CAL_VIEW;

/***Drop Procedure***/

DROP PROCEDURE “KN227869”.“INSERTDATA”;

/*** Drop Column Table ***/

DROP TABLE “KN227869”.“T_TABLE”;