User Guide Cancel

Autogenerate database schema

ColdFusion automatically creates tables when ORM is initialized for the application. For auto-generating tables, do the following:
In the THIS scope of Application.cfc, in ormsettings struct, set the dbCreate property to one of the following values:

  • update: Creates the table (if it does not exist) or updates the table (if it exists).
  • dropcreate: Drops the table if it exists and then creates it.
    For example,

<cfset this.ormsettings.dbCreate="update">
<cfset this.ormsettings.dbCreate="update">
<cfset this.ormsettings.dbCreate="update">

Certain specific attributes (DDL-only attributes) defined for the tags cfcomponent and cfproperty can be use to define various attributes for the auto-generated tables and columns. DDL-only attributes are used only for DDL generation. For details of these attributes, see the table in the section DDL-only attributes in Column.

Get help faster and easier

New user?