Skip to main content

Add a column to a table and modify the projection to use the new column in ORDER BY

  • August 1, 2013
  • 1 reply
  • 7 views
May_1
Forum|alt.badge.img+1
  • May_1
  • Participating Frequently
We are adding a column to the table and plan to use the column in the ORDER BY clause of the projection. We have a single projection on the table. Can I alter the projection adding the new column to the ORDER BY clause, and refresh the projection? I know we could create new projection, refresh the projection and then drop the current projection, but we don't have that much space to do so. Is there a way to do a "in-place" replacement/refresh of the projection?

    1 reply

    Shobhit_Garg
    Forum|alt.badge.img
    • Shobhit_Garg
    • Participating Frequently
    • September 5, 2013
    Hello,

    Unfortunately Alter projection only supports rename.
    In your scenario you have to create a new projection and refresh it and the drop the existing projection and rename the new one.

    Thanks
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement