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).
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;