Database tables and API classes

  Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic! Mail us feedback on this topic!  

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:


Adding an item into a custom table
Getting items from a custom table
Editing a custom table item
Deleting a custom table item
A complete example


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.


Page url: