How to make DB changes to tables that don’t appear in DB Admin

There are occasions when you might want to make changes to a module that is not normally available via the DB Admin tool e.g. changing the size of the Status ID field in the User Defined Status module. So how do you make these modules available?

The trick lies in the SMSYSFLAGS table. Open the SMSYSFLAGS table in SQL Enterprise Manager or equivalent and scroll down until you find the row with a Name = TableExclusions and a Value = GMT;SLA Default;Group Details;User Defined Status; etc.

Change the Value column to GMT;SLA Default;Group Details;zUser Defined Status; etc. i.e. Just put a ‘z’ in front of User Defined Status.

When DB Admin loads it excludes any modules it finds in this list. As User Defined Status is now no longer in the list (because it has been renamed to zUser Defined Status) it will not be excluded and will appear for editing in DB Admin.

Advertisements

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s