Skip to Content
avatar image
-1
Former Member

HOW TO CREATE A TABLE USING LIKE OPTION WITHOUT CONSTRAINTS

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 02 at 09:47 AM

    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.

    Add comment
    10|10000 characters needed 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