CREATE OR REPLACE TYPE

[rhavin]

How do I create or replace a type in HANA 2.0 SP5?

I want to create a type if it currently does not exist. How do I do that?

[Craig-Zhang]

Hello,

Can you please clarify what is the "type" so that we can help?

Best regards,
Craig

[simon25]

Hi, 

I believe you're looking for the CREATE TYPE for table which can be found here in the guide :
CREATE TYPE Statement (Procedural)

Create a table type called tt_publishers.

CREATE TYPE tt_publishers AS TABLE (
publisher INTEGER,
name VARCHAR(50),
price DECIMAL,
cnt INTEGER);

Kind Regards
Simon

[rhavin]

No @simon25 "Product and Topic "Expert"" I'm not looking for the nonhelpful guide. I asked a simple question and it is marked BOLD.