TableOption

abstract class TableOption

Base class for table options that are appended at the very end of CREATE TABLE statements, after the closing parenthesis of the column definitions block.

Table options are database-specific settings that appear after the ) that closes the column definitions and before any WITH clause. Commonly used for MySQL/MariaDB storage engines, character sets, and other vendor-specific options.

Important: Table options are only applied during table creation and are not tracked by Exposed's migration system. Changes to options will not be detected automatically.

Example SQL structure:

CREATE TABLE users (
id INT,
name VARCHAR(50)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 -- Table options appear here
WITH (fillfactor=70) -- Storage parameters appear here

Inheritors

Constructors

Link copied to clipboard
constructor()

Functions

Link copied to clipboard
abstract fun toSQL(): String

Returns the SQL string representation of this option.

Link copied to clipboard
open override fun toString(): String