Results 1 to 3 of 3

Thread: BLOB_Compact

  1. #1
    Join Date
    Nov 2016
    Posts
    2

    Unanswered: BLOB_Compact

    Hi,

    I need to compact BLOBs in the table and I saw that is possible with the ALTER TABLE, but does anyone here has an example on how to do it with "compact" option.

    Thanks in advance

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    294
    Provided Answers: 45
    Hi,

    Such a column attribute alteration is not listed in the "column-alteration" block in the ALTER TABLE description.
    So, there is no way to do it with a single ALTER TABLE statement.
    Regards,
    Mark.

  3. #3
    Join Date
    Nov 2016
    Posts
    2
    Hi,

    thank you for the answer. You have right. I've found already that I need to drop and add column with this option...

    kr

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •