View/Edit Table Schema
View the database schema instantly, expand columns, and edit the structure of your database.
A table schema consists of all the objects in the database, including tables, functions, and stored procedures. Arctype allows you to quickly view and edit your schema, which saves time when modifying your database's structure.
To view all the columns in your table and their data types, navigate to the “Table” view and select the arrow next to one of your tables. This will open up a dropdown menu that will display each column name and its corresponding data type.
To edit the table schema from the table view, click on the table you want to edit. This will open the table in the table view. You can inspect the table schema by viewing the column names and data types at the top of the table.
To edit a data type from this view, select the column you wish to change. A box will appear, allowing you to change the column name and the data type of the column. Choose your desired options, and then select “Save” to save your changes. You can also discard your changes by choosing “Cancel.”
This method of editing your schema is less robust than the full schema editor approach described below, but is handy and convenient for quick modifications.
Use Show Table Schema to see foreign keys and indexes in Arctype
Next to the Refresh button in the top right are 3 dots with more options for table view. Click this and select Show Create Schema. A right side pane will pop out that shows each column, its type, any foreign keys, and any indexes. Each index and foreign key is clickable to see the SQL to generate it or go to the table that is being linked.
Sometimes it is necessary to see more information about your tables such as the default values, constraints, checks, and foreign keys for your columns.
To edit the table schema from the table editor, right-click on the table you wish to edit in the left navigation pane and choose “Edit table...”, as shown below.
This will open the schema editor. The schema editor is a powerful tool that you can use to configure your schema. It allows you to configure your schema with a high degree of detail and flexibility.
From the schema editor, you can choose names for each column, choose the data type for each column, set default values, and define constraints, checks, and foreign keys.
You can delete columns by pressing the
Xnext to them. Choosing
Add indexin the top right corner will also allow you to add a column or index. You can also change the Table name and schema definition from this view.
When you're satisfied with your changes, select
Reviewto review them and ensure they match your desired schema modifications.
When everything looks good, click
Applyto put your changes into effect. You'll see a success message in the bottom right corner when your changes are applied.