Manage the tables in a database

• Add a table
• Copy a table
• Edit table settings
• Close and reopen a table
• Delete a table

Add a table

When you create a database, it contains at least one table. 

To add a table to a database:

1. Open the database in the database editor.
2. 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. 

Copy a table

To copy a table:

1. Open the database in the database editor.
2. Position your cursor over the table tab.
3. Select More  > Copy table.
   The Copy this table dialog displays.
4. Select Copy table rows to copy the rows in the existing table to the new table.
5. Click OK.

A new table is added to the database and named Copy of tablename.

Edit table settings

To edit table settings:

1. Open the database in the database editor.
2. Position your cursor over the table tab.
3. Select More  > Table settings.
4. 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 and Time 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.

5. Click Save.

Close and reopen a table

To close a table in the database editor:

1. Open the database in the database editor.
2. Position your cursor over the table tab.
3. Select More  > Close.

To reopen a table in the database editor:

1. Open the database in the database editor.
2. Click  + Add Table > Load existing table.
3. Select the table you want to reopen.

Delete a table

To delete a table:

1. Open the database in the database editor.
2. Position your cursor over the table tab.
3. Select More  > Delete table.
4. Click OK to confirm the delete operation.