AI agents: the content index is at /llms.txt. Every page is also available as Markdown — send the request header Accept: text/markdown, or append .md to the page URL.
Xperience Docs

Cookie consent

We use necessary cookies (opens in a new tab) to run our website and improve your experience while browsing. Additional cookies are only used with your consent. You may revoke your consent on the Cookies Policy (opens in a new tab) page or in your browser at any time.

Configure (opens in a new tab)
  • Documentation
    InstallationUsing the Xperience interfaceDeveloping websitesConfiguring XperienceManaging usersSecuring websitesDeploying websitesManaging website contentMultilingual websitesMacro expressionsExternal utilitiesIntegrating 3rd party systemsCustom developmentE-commerce featuresOn-line marketing featuresRelease notes - Xperience 13Xperience terminology glossary
  • Tutorial
    Using the Xperience interfaceDeveloper tutorialBusiness tutorialResource hub for marketers
  • API Examples
    ConfigurationContent managementDevelopmentE-commerceOn-line marketingSocial media
  • Community Questions & Answers (opens in a new tab)
  • Contact support (opens in a new tab)
  1. Home
  2. Developing websites
  3. Defining website content structure
  4. Managing custom tables
  5. Custom table internals and API

Custom table internals and API


Was this page helpful?

Send us feedback Go back to top

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_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

All default Custom table classes are 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.

On this page

  • Database tables
  • API classes

Related pages

  • Managing custom tables
  • Database table API