DB Manager provides functions to create, rename, edit, delete, and empty tables using tools found under the Table menu. In this section, we will discuss each tool.
Creating a new table
Creating new tables using DB Manager is fairly straightforward. When creating a new table, you can specify whether it will be a spatial table or a nonspatial table. In this section, we will create a new spatial table in SpatiaLite to hold data about mountain peaks in a park; to do this, perform the following steps:
To quickly create a new SpatiaLite layer (and optionally a database) in one dialog box in QGIS Desktop, navigate to Layer | Create Layer | New SpatiaLite Layer….
- Open DB Manager by clicking on DB Manager under Database. Expand SpatiaLite ...