Skip to content Skip to main navigation Skip to footer

Database Manager

Database is the required data source for editing geometry and performing any data editing, calculations, or analysis. To learn more about importing and what you can do with the data that resides in the database, take a look at this guide.

Database Manager can be found under Tools tab. Clicking the Database Manager button opens the Database Manager options window.

List of Database Manager functions

  1. Database Connection – Select the database you want to use.
  2. Action – List of available database management actions.
    • Refresh – Refreshes the table list.
    • Select all
    • Unselect all
    • Rename – Select the table and change its name.
    • Edit fields – Edit the structure of the table (add or delete columns). Take a look at our guide on editing table structure.
    • Duplicate – Makes a copy of the table.
    • Reset metadata – Reset metadata cache of features etc from the selected tables.
    • Truncate – Deletes all data from the table, but saves the table structure.
    • Delete – Deletes the table.
  3. Import Geospatial file – Tool for adding layers into a database.
    Learn more about Importing geospatial files.
  4. Import CSV or XLS – Tool for adding CSV or XLS files to the database.
    Learn more about Importing CSV or XLS files.
  5. Join Wizard – Tool for joining layers.
    Learn more about the Join Wizard.
  6. Filter – Enables database search.
  7. All/Spatial/Non-Spatial – Displays all or spatial/non-spatial tables.
  8. Quick action – When pointing mouse above layer displays Edit and Delete option.

Find out more about Database as data source.

Was This Article Helpful?