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.

View Columns

To view all the columns in your table and their datatypes:

  • Click SQL Client in the left sidebar

  • Select Tables in the SQL Client menu

  • Click the sideways down arrow button next to the table name

View and Edit Full Table Schema

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 View or Edit Your Full Table Schema:

  • Click SQL Client in the left sidebar

  • Select Tables in the SQL Client menu

  • Right click on the table and select Edit Table or click on the Edit Table button in the table viewer toolbar.

From here , you can view or modify default values, constraints, checks, and foreign keys for all your columns, or add a new column by clicking ADD COLUMN at the bottom. You can also delete a column by clicking the x to the right side of the column. Make sure to click EDIT TABLE to save your changes, or CANCEL if you are just viewing.

If you press enter after modifying a field, your changes will be saved even if you do not click Edit Table