# 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

Content copied to clipboard

#### Inheritors

EngineOption
CharsetOption
RawTableOption

## Constructors

TableOption
Link copied to clipboard
constructor()

## Functions

toSQL
Link copied to clipboard
abstract fun toSQL(): String

Returns the SQL string representation of this option.

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