Change
Schema Editor
Schema Editor provides a visual interface for modifying database structures without writing SQL.
Getting Started
Access Schema Editor by:- Creating a new plan: CI/CD > Plans > New Plan > Select
Schema Migration - From database page: Database > Databases > Select database > Edit Schema
Basic Operations
Tables
- Create: Click New Table or use
···menu next to a schema - Duplicate: Click the copy button on any table row
- Delete: Click
···> Drop table (use Restore to undo) - Rename: Available for newly created tables only
Columns
- Add: Select table > Click Add Column > Configure properties
- Modify: Click on existing columns to edit properties
Schemas
Use the··· menu on database/schema rows to create, drop, or restore schemas.
Apply Changes
Click Preview Issue to review generated SQL and create a change issue.Schema Templates
Create reusable components for consistent database design. Configure templates in Settings > Schema Template.Field Templates
Pre-defined columns that can be added to any table.- Create: Add Field Template > Configure properties > Create
- Use: In Schema Editor, select table > Add from template
Table Templates
Complete table structures with predefined columns.- Create: Add Table Template > Define structure > Create
- Use: In Schema Editor, select database > Add from template
Column Type Restrictions
Limit available column types to enforce standards.- Go to Column Type Restriction > Select “Allow limited types”
- Remove unwanted types from the allowed list