Remove a table manually from SLOX

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

=======================

Caution: Deleting a column through the Architect will also remove any trigger of this table, even the trigger doesn’t refer to the deleted column.  Adding columns is OK.

Advertisements
This entry was posted in SalesLogix. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s