Replicating tables and columns added with the SQL Table and SQL Columns forms

When you use the SQL Tables form, the SQL Columns form, and the SQL Table Primary Key form to create custom tables, the new tables are set up with the appropriate columns, indexes, and triggers, so that they are treated by the system just like any other base table.

If you set up the same custom table in multiple sites, you can include the table in replication categories and create replication rules between those sites. The table schema must be exactly the same at each site.

You can also use the SQL Tables form to indicate whether a table has a site-splitting column. A site-splitting column indicates that individual records in a table are not shared by every site. If a table does not include a site-splitting column, then all sites in the same database share the same records in the table. In some Mongoose-based applications, the site-splitting column is named site_ref.

You can use the SQL Columns form to add custom columns to base tables. If the base table has an _all table, you can also add the new columns to the _all table in order to replicate the data. If you do this, add the columns to both the base table and the _all table in each site that is replicating the _all table data.