View/Edit Table Schema

Search…

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 

Connections - Previous

Managing and Switching Data Sources

Next - Managing Tables

Creating a Table

Last modified 5mo ago

Copy link

Contents

View Columns

View and Edit Full Table Schema