Custom table internals and API

Database tables

Custom tables uses the following database tables:

Database table

Description

CMS_Class

Custom tables are stored as classes in the system database, this database table is used for storing information about classes.

CMS_ClassSite

This table is used to assign classes (and therefore also custom tables) to particular sites in the system.

CMS_Query

Contains records representing SQL queries for operations with data in custom tables, along with other queries used by the system.

CMS_Transformation

Contains records representing transformations for custom tables data, as well as other transformations used by the system.

CMS_AlternativeForm

Contains records representing alternative forms for particular custom tables, together with other alternative forms used by the system.

<prefix>_<table code name>

Particular custom tables are stored as standard tables in the system database. You can distinguish them by giving them a descriptive prefix, while the customtable_ prefix is used by default.

API classes

You can find all Custom table classes under the CMS.CustomTables namespace. See our API examples for code samples illustrating this functionality.

Class

Description

Custom Tables API

CustomTableItem

Represents one custom table object.

CustomTableItemProvider

Provides management functionality for custom tables.