Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, March 29, 2024 
 
Dropping SalesLogix Tables  
Description:  Having recently done and upgrade from a rather old DB to v7.0.1, I've encountered a few tables that cannot be deleted from SalesLogix via DB manager. This sample shows the process to completely drop a SalesLogix table.

Category:  Code Samples
Author:  Todd Hardin
Submitted:  6/1/2007
   
Stats: 
Article has been read 20498 times

Rating: - 5.0 out of 5 by 5 users
 

fiogf49gjkf0d
Dropping SalesLogix Tables

Having recently done and upgrade from a rather old DB to v7.0.1, I've encountered a few tables that cannot be deleted from SLX via DB manager. Examples are: USEROPTION (not the new USEROPTIONS ), and PROJECTPLUGIN

This article includes a script that drops the table and deletes records from the three SalesLogix schema meta data tables.

Here is a summary:

drop table YourTableName
delete from sectabledefs where tablename = 'YourTableName'
delete from joindata where fromtable = 'YourTableName' or totable = 'YourTableName'
delete from resynctabledefs where tablename = 'YourTableName'


 Click here to download the sample code

 

About the Author

Todd Hardin
(SalesLogix Business Partner)
Sage - PSG

fiogf49gjkf0d
Long time SLX Consultant and SLX Fanatic - Go SLX!
Have been working with SLX from the very first release
Hobbies: SCUBA, SCUBA, SCUBA! - I am an SSI SSCUBA Instructor


View online profile for Todd Hardin
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Author Article Comments and Discussion
Dave
 

Re: Dropping SalesLogix Tables
Posted: 8/30/2007 2:22:31 AM
fiogf49gjkf0d
Very fine, even if it should be mentioned that also the PLUGIN table contains a record (XMLSCHEMA) that is affected by TABLES "movements"...

If you do run:

SELECT data FROM plugin WHERE pluginid = 'XMLSCHEMA'

within WGADMIN you can see the entire DB's tables definitions

I think that this will be entirely rewrote once you change anything from SLX DB Manager.
But it would be interesting to understand when this plugin is read.
I'll try to trace it with SLXProfiler and let you know!
 
 

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 3/29/2024 2:13:31 AM