Prev
Next
Forums S3 Systems Administration

Removing Custom Tables

Sort:
You are not authorized to post a reply.
Author
Messages
This_Guy
Veteran Member
Posts: 93
Veteran Member
7/2/2015 4:42 PM

    Trying to remove Custom tables that are no longer used, but have several custom programs tied to them. I cant simply just DROP TABLE in SQL because of the programs that are using the table references, GEN ties, etc... same with dbdef. Cant do it. 

    Is there an easy way to get rid of those, and all possible residual usage/references to these tables?  

    Kwane McNeal
    Veteran Member
    Posts: 479
    Veteran Member
    7/2/2015 4:50 PM
      If there are programs that still call them, then by definition that are still used.

      I agree you can't just drop them, but getting rid of them easily will be inversely related to how intricately they are embedded in the affected programs.

      You should have a developer, if you aren't one yourself, look at the code in question, and assess the effort.

      This_Guy
      Veteran Member
      Posts: 93
      Veteran Member
      7/2/2015 4:58 PM
        Yeah, we are headed that way with our Developer team. Just didnt know if someone had a "trick" Thanks.
        Kwane McNeal
        Veteran Member
        Posts: 479
        Veteran Member
        7/2/2015 5:04 PM
          No. There's not a set of magic tricks for this one. Sorry
          You are not authorized to post a reply.