Add a table
When you create a database, it contains at least one table.
To add a table to a database:
- Open the database in the database editor.
- Click + Add Table > Create new table.
A new blank table is added to the database and named Table_n, by default, where n is incremented by 1 each time you add a new table. You can change the table name and other properties, as described in Edit table settings.
- Pasting data over
Lookup
column data types is not supported - Pasting values that do not match the options in a drop-down column results in the values being removed
Copy a table
To copy a table:
- Open the database in the database editor.
- Position your cursor over the table tab.
- Select More > Copy table.
The Copy this table dialog displays. - Select Copy table rows to copy the rows in the existing table to the new table.
- Click OK.
A new table is added to the database and named Copy of tablename.
Edit table settings
To edit table settings:
- Open the database in the database editor.
- Position your cursor over the table tab.
- Select More > Table settings.
- Modify one or more of the following settings:
Setting
Description
Table name
Edit the name of the table. Must be unique within the database.
Table description.
Add a description of the table.
Table time zone
Select a timezone from the drop-down list.
Table locale Select the locale used for Date
andTime
columns formats (for example: 9/22/22, 1:38 PM)Table-to-table permissions
Manage read access permissions by other tables in the database.
Table-to-table permissions are added automatically when you add a
Reference
column in a table.Note: If you remove a table-to-table permission, it will cause any linked columns that rely on the permission to break and fail.
- Click Save.
Close and reopen a table
To close a table in the database editor:
- Open the database in the database editor.
- Position your cursor over the table tab.
- Select More > Close.
To reopen a table in the database editor:
- Open the database in the database editor.
- Click + Add Table > Load existing table.
- Select the table you want to reopen.
Delete a table
To delete a table:
- Open the database in the database editor.
- Position your cursor over the table tab.
- Select More > Delete table.
- Click OK to confirm the delete operation.