The following sql should get you the projection definition: select * from projection_columns where projection_name='name_of_your_projection' order by sort_position, column_position; To find the projection_name: select * from projections where anchor_table_name='table_for_which_projection_was_created';