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
