Skip to Content
-1

HOW TO CREATE A TABLE USING LIKE OPTION WITHOUT CONSTRAINTS

May 02 at 08:27 AM

33

avatar image
Former Member

Hi All,

I am trying to create a column table using LIKE operator. But I don't want the constraints in the target table.

How do I achieve this?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
May 02 at 09:47 AM
0

The documentation of the command specifically mentions how to do this.

I recommend, as always, reading the documentation before posting questions that show the whole Internet that you don't read the documentation...

Also: putting usernames into tags does not lead to notifications.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Lars,

The WITHOUT CONSTRAINT clause is available only from HANA 2.0 SPS01 onwards.

And I was specifically looking for HANA 1.0 SPS12.

Based on this and after going through the documentation only I had posted this.

While posting the query I missed mentioning the HANA version. My Bad.

Anyways thanks for your help.

Regards,

Sami

0