.. 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