Skip to Content
Actions

HANA Tips and Tricks

July 9, 2012 | 73 Views |
 hana devcentersap hana
Follow

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

To report this post you need to login first.

1 Comment

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

Leave a Reply