Skip to Content
Author's profile photo Former Member

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Andy Silvey
      Andy Silvey

      Hi Karthik,

      nice Technical Blog.

      Thanks.

      Andy.