Adding UET schema changes to _all tables and views

If you modify a base table schema with the User Extended Tables (UET) function, then the same UET columns/indexes are automatically added to the corresponding _all table. Impacting the schema using the UET Impact Schema utility automatically regenerates the table triggers for the base table to populate the new columns in the corresponding _all table at the current site.

The system also regenerates the views to base tables. UET fields are included in the view if the base table includes them.

After modifying the base table, you must go to the Replication Management form and click Regenerate Replication Triggers. This re-creates the appropriate replication triggers and stored procedures based on the latest table schema changes.

Note: You must regenerate replication triggers any time you change, add, or delete UETs.

If an _all table is shared

If an _all table is shared in an intranet, the _all table resides on the master site, and UET fields should be changed there. After making the change, go to the Replication Management form on the master site, and click Regenerate Views to Master Site.