Skip to Content

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

1 Comment
You must be Logged on to comment or reply to a post.