Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Sunday, July 14, 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
Article has been read 20692 times

Rating: - 5.0 out of 5 by 5 users

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

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

Re: Dropping SalesLogix Tables
Posted: 8/30/2007 2:22:31 AM
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): 7/14/2024 2:08:37 AM