.. include:: /Includes.rst.txt .. The following reference was automatically generated from code. It should not .. be changed directly. .. _typo3_console-command-reference-database-updateschema: ===================== database:updateschema ===================== **Update database schema (TYPO3 Database Compare)** Compares the current database schema with schema definition from extensions's ext_tables.sql files and updates the schema based on the definition. Valid schema update types are: - field.add - field.change - field.prefix - field.drop - table.add - table.change - table.prefix - table.drop - safe (includes all necessary operations, to add or change fields or tables) - destructive (includes all operations which rename or drop fields or tables) The list of schema update types supports wildcards to specify multiple types, e.g.: - "`*`" (all updates) - "`field.*`" (all field updates) - "`*.add,*.change`" (all add/change updates) To avoid shell matching all types with wildcards should be quoted. **Example:** .. code-block:: shell typo3 database:updateschema "*.add,*.change" .. code-block:: shell typo3 database:updateschema "*.add" --raw .. code-block:: shell typo3 database:updateschema "*" --verbose Arguments ========= `schemaUpdateTypes` List of schema update types Options ======= `--dry-run` If set the updates are only collected and shown, but not executed - Accept value: no - Is value required: no - Is multiple: no - Default: false `--raw` If set, only the SQL statements, that are required to update the schema, are printed - Accept value: no - Is value required: no - Is multiple: no - Default: false