Working with All Metadata Update Procedures

Reference for bulk create, update, and drop operations across class tables, with IncludeInApp filtering.

Check Class Table List

SELECT * FROM MFClass;

First Synchronization

EXEC spMFSynchronizeMetadata;

Bulk Operations on Class Tables

Set IncludeInApp to any value (note: 1 and 2 are reserved; 2 should only be used for classes where transaction update is required). .. code-block:: sql

UPDATE MFClass SET IncludeInApp = 3 WHERE ID IN (418, 420, 422);

Show Quick Stats on All Tables

EXEC spMFClassTableStats;

Show Stats for a Single Table

EXEC spMFClassTableStats 'MFCustomer';

Create All Class Tables with IncludeInApp 1 or 2

EXEC spMFCreateAllMFTables;

Create More Class Tables

UPDATE MFClass
SET IncludeInApp = 3
WHERE MFID IN (14, 85);

Update Records for All Class Tables with IncludeInApp = 1

EXEC spMFUpdateAllncludedInAppTables 1;
--or
EXEC spMFUpdateAllncludedInAppTables @UpdateMethod = 1;

Drop All Class Tables with a Specific IncludeInApp

EXEC spMFDropAllClassTables 1; -- does not reset IncludeInApp to allow for recreation
--or
EXEC spMFDropAllClassTables @IncludeinApp = 1;