Schema Editor provides a spreadsheet-like editor to view and edit database structure. Users first use the Schema Editor to prepare the schema changes, then those changes will be converted into SQL statements and go through the change workflow.Schema Editor also supports the use of templates for fields and tables. Templates can be pre-defined at the workspace level and can be used to save time and ensure consistency when creating new schema entities. See Schema Template for more details.
While creating a new plan within a project, go to CI/CD > Plans in the left menu, and click New Plan. Choose Schema Migration as the plan type and click Next. Select one database and click Next. You will see the Schema Editor.Alternatively, you can go to Database > Databases in the left menu, select one database and click Edit Schema.
To create a new table, select a database and click the New Table button on top of the Edit Schema page. Enter table name and Create.You can also create a new table by clicking the ··· button by a schema, then click the New table button and enter your Table Name. Click the Create button, and you’ll have created a table under this schema.Similarly, you can click the ··· button on the database row to create a new schema under it.By clicking on the copy button on the table’s row, you can replicate this table.
To drop an existing table / schema, click the ··· button on the corresponding row of the database / schema list, and click the Drop table / Drop Schema button. Then this table / schema will be crossed out.Click on the ··· button of a table or schema you just dropped, and you can Restore it.
To Add a new column, click on a table and click the Add Column button on top of table detail page.Enter attributes for this column: Name, Type, Default, etc.
