Where are the content types stored in the database?

Question

In Drupal 7 with this query:

SELECT * FROM node_type;

I can obtain the list of all my content types, now in Drupal 8 I can't find the node_type table.

I know that with this code:

$content_types = \Drupal::service('entity.manager')->getStorage('node_type')->loadMultiple();

$content_types_list = [];
foreach ($content_types as $content_type) {
  $content_types_list[$content_type->id()] = $content_type->label();
}

I can obtain the info, but where is this information stored now in the database?

Answer 1

It's configuration. Like any other config entity and simple configuration, it is stored in the {config} table.

But using the entity API is the only supported way to load that information, do not query that table directly.

Answer 2

As answered earlier, it is stored in the {config} table. To be more specific:

• If the machine name for a content type is "blogpost", there will be a record in the {config} table with name="node.type.blogpost".
• The data field will contain a PHP serialized array with the configuration details of the content type. This must be reasonably valid in order for the content type to be listed on the /admin/structure/types page.
• If you create a content type via the UI, it will also create the following {config} records (though these are not necessary to be listed on the /admin/structure/types page):
  • core.entity_form_display.node.{type}.default
  • core.entity_view_display.node.{type}.default
  • core.entity_view_display.node.{type}.teaser
  • field.field.node.{type}.body

For writing production code, I would echo the earlier recommendation not to directly query the {config} table. However, using these details to query the table could be helpful for things like debugging a failed migration.