Static Tables

Phil Bell
Phil Bell
Sixth Anniversary Name Dropper Participant Facilitator 1
in Blackbaud Raiser's Edge NXT®: General Discussions
Hi 

I am in the process of tidying up our RE database and I see that we have over 3500 Static tables. I know that these are setup via queries but what would be the implication(s) of simply removing them all ?
Tagged:

Comments

  • Joshua Bekerman bCLO, bCRE
    Joshua Bekerman bCLO, bCRE
    Tenth Anniversary Kudos 5 Name Dropper Participant
    If you are referring to the tables in SQL Server I wouldn't touch them. Delete the Query in RE instead but make sure no one is still using the query. Also make sure the query is not needed for an export or report.  The one time in my 20+ years of using RE that I deleted queries was also the one time my boss needed them a week later.  ?

Categories