Base can display and edit all aspects of a table schema in a compact, easy to read view.
To show the schema of a table:
- Select the Schema tab of a document window
- Choose the table you want to view from the list on the left of the window
What's what in the Schema View
By default, Base shows three columns in the upper half of the Schema View:
- Column name
- Column type
- Column constraints
From left to right, the constraint icons represent:
- Primary Key
- Not Null
- Unique
- Check
- Default
- Collate
- Foreign Key
The lower half of the window contains the CREATE statement for the table and any indexes or table constraints. You can choose which to view by clicking on the pop-up button in the lower half of the view.