Query: Branches derived from the main branch

Description

Discover the segments that have been created from the main branch in a specific database, which can be useful when tracking the evolution of your data and managing your database structure.

Query

Tables used in this query:

• planetscale_database_branch

SQL

select
  *
from
  planetscale_database_branch
where
  database_name = 'test'
  and parent_branch = 'main';

select
  *
from
  planetscale_database_branch
where
  database_name = 'test'
  and parent_branch = 'main';