Managing tables
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:
Tip
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 ...
Get Mastering QGIS - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.