(Quick Reference)

table

Purpose

Customizes the name of the database table associated with the domain class

Examples

class Book {
    static mapping = {
        table "book_catalog"
    }
}

Description

Usage: table(string/map)

Arguments:

  • name - The table name
  • schema (optional) - The table schema
  • catalog (optional) - The table catalog

By default the table that Grails maps a domain class is based on the class name. Grails will take a class name and convert Java style camel-case names into table names with underscores. So for example ProductReview becomes product_review. You can override this with the table method:

static mapping = {
    table "book_catalog"
}

You can also specify a schema and catalog:

static mapping = {
    table name: "book_catalog", schema: "dbo", catalog: "CRM"
}