Custom tables allow you to create your own tables in the system database. You can manage the data in custom tables without using Microsoft SQL Server Management Studio or any other database management tool. You will find this useful especially when you need to store a large number of items in a flat data structure. Standard Kentico pages are not as efficient as custom tables for storing items in a flat structure. Refer to Storing data effectively for more information on the advantages of using custom tables over Pages.
To learn how to load and display data from custom tables on the live website, see:
- Retrieving content in MVC applications
- Displaying data from custom tables (Portal Engine)
- Writing transformations for custom tables (Portal Engine)
Data stored in the tables can be searched using locally stored search indexes. You can also create alternative forms for the tables. These forms can be used instead of the default forms for creating or editing custom tables in the administration interface, as described in Code names of automatically used alternative forms.
You can use custom tables to store the data of custom-developed modules. Developers can handle custom tables and their data via the custom table API.
Custom table object type
If you need to specify the type of the records in a custom table, use the following naming convention:
For example, a custom table with code name CustomTable.Users has records of type: