The Custom tables module uses the following database tables:
|•||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 - SQL queries for operations with data in the custom table are stored in this table, along with other queries used by the system|
|•||CMS_Transformation - transformations for custom tables data are stored in this table, as well as other transformations used by the system|
|•||CMS_AlternativeForm - alternative forms for particular custom tables are stored in this table, together with all 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|
The Custom tables API is provided by the following CMS.SiteProvider namespace classes:
|•||CustomTableItem, CustomTableItemProvider - these classes provide functionality for managing data items stored in custom tables|
The following topics show how methods from these classes can be used to manage custom tables data:
The API programming and Kentico CMS internals section of this guide contains more API related information, so please refer to it if required.
For detailed API documentation, such as a list of all methods from the classes above, please refer to Kentico CMS API Reference that is a part of your Kentico CMS installation and can be accessed through the programs folder in Windows Start menu.