HANA Tips and Tricks

Follow RSS feed Like

0 Likes 1,417 View 1 Comment

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.