Skip to Content
0

HANA DB and deleting a column

Jun 30, 2017 at 10:36 AM

61

avatar image

In table /POSDW/TLOGF a customer append exists. In this append structure fields have been inserted and deleted again. The table is active and has been adjusted accordingly through SE14. In SE11 everything looks ok.

When we view the table on the HANA database, the deleted columns are still visible. Is this the default HANA DB behaviour? Or did something go wrong or still needs to be done?

I know i can use ALTER TABLE ... DROP column to remove the columns but i'm not sure whether this is the correct approach.

Anyone encountered the same situation and how did you deal with it?

edit: just did a check through SE14 and result is: database object inconsistent with runtime object.

Kind regards,

Guus

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

1 Answer

Best Answer
Guus Werinussa Jun 30, 2017 at 10:58 AM
0

Never mind. After googling a bit more i found this with the solution.

https://wiki.scn.sap.com/wiki/display/TechTSG/Inconsistency+occurs+on+database+object+check

Share
10 |10000 characters needed characters left characters exceeded