Skip to main content
drupalreleases

Use direct release data with your AI assistant.

Learn more

Schema

Security covered Under active development 2,469 sites

Part of the Schema ecosystem · 25 projects

The Schema module provides tools for managing database table structures within Drupal. It helps module developers declare and interact with database tables, inspect the live database to generate schema structures, and compare the declared schema with the actual database to identify discrepancies.

Introduced in Drupal 6, the Schema API allows modules to declare their database tables in a structured array (similar to the Form API) and provides API functions for creating, dropping, and changing tables, columns, keys, and indexes.

The Schema module provides additional Schema-related functionality not provided by the core Schema API that is useful for module developers. Currently, this includes:

  • Schema documentation: hyperlinked display of the schema's embedded documentation explaining what each table and field is for.
  • Schema structure generation: the module examines the live database and creates Schema API data structures for all tables that match the live database.
  • Schema comparison: the module compares the live database structure with the schema structure declared by all enabled modules, reporting on any missing or incorrect tables.

Note for MySQL users: The Schema module requires MySQL 5. Prior versions of MySQL do not support the INFORMATION_SCHEMA database that the Schema module uses to inspect the database.

Related modules

  • Schema reference field: adds a new field type that uses Schema to let you refer to database connections, tables, and/or columns.

Ask your assistant about Schema

Check compatibility with your Drupal and PHP version, maintenance and security coverage, from current release data. How it works

Depends on

Dependencies of the latest stable release

No dependencies recorded for this project.

Required by

Tracked projects that depend on this one

No tracked projects depend on this one yet.

Activity

Tracked releases
1
Tracked since
Jun 2024
Latest release
2 years ago
Releases (12 mo)
0
Maintenance
Dormant

Releases

Version Type Core PHP Release date
2.0.0-alpha3 Pre-release 9–10 Jun 1, 2024