• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Removing Custom Tables

 3 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
This_Guy
Veteran Member Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
Posts: 479
Veteran Member
7/2/2015 5:04 PM
No. There's not a set of magic tricks for this one. Sorry