REQUEST A DEMO

Manually removing a view from the Clarify schema

I had one of the views in my database end up in a really bad state recently, so I had to manually drop the view.

This is mostly a post so I have it as a reference should I need to do this again in the future. Google search FTW.

SQL statements to manually remove a view (on MSSQL)

Here I’m removing table_fc_user_case_view with id of 4650

  • delete FROM adp_view_field_info  WHERE view_type_id = 4650
  • delete  FROM adp_sch_info  WHERE type_id = 4650
  • delete  FROM adp_view_join_info  WHERE view_type_id = 4650
  • delete  FROM adp_tbl_name_map WHERE type_id = 4650
  • drop view table_fc_user_case_view