Skip to Content
avatar image
Former Member

ALter the datatype of a Table type

Hi All,

I am trying to alter the length and datatype in a Table type but I am getting errors. Am I wrong somewhere I have used the same syntax which I use for table alteration. Please help.

alter "Sales-Product"."TT-Sales" alter (SALES_AMOUNT DOUBLE,NET_AMOUNT DOUBLE,

             SUB_REGION_NAME VARCHAR(100) , REGION_NAME VARCHAR(100))

Error: SAP DBTech JDBC: [257] (at 7): sql syntax error: incorrect syntax near "Sales-Product": line 1 col 7 (at pos 7)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 02, 2015 at 05:13 PM

    Hi ,

    please use below syntax:

    alter table "Sales-Product"."TT-Sales"(

    SALES_AMOUNT DOUBLE,NET_AMOUNT DOUBLE,

                 SUB_REGION_NAME VARCHAR(100) , REGION_NAME VARCHAR(100))

    Regards,

    sai Krishna.


    Add comment
    10|10000 characters needed characters exceeded