Home/SQLite/Managing databases and tables in SQLite

Managing databases and tables in SQLite

This series of tutorials shows you how to manage databases and tables in SQLite.

1 How to Create a New SQLite Database in Seconds

2 Connecting to SQLite Using the Command Line Interface

3 Writing Code to Connect to SQLite: A Beginner's Guide

4 Mastering SQLite CLI: Basic Commands You Need to Know

5 Executing Your First SQL Commands with SQLite

6 Understanding SQLite .help and .mode Commands

7 Step-by-Step Guide to Creating Tables in SQLite

8 SQLite Table Creation Syntax Explained with Examples

9 What Are Temporary Tables in SQLite?

10 How to Use Views in SQLite for Query Optimization

11 Modifying Tables in SQLite Without Breaking Your Data

12 Adding and Dropping Columns in SQLite Made Simple

13 How to Rename Tables and Columns in SQLite Safely

14 Deleting Data Structures: SQLite DROP TABLE and DROP VIEW Explained

15 How to export SQLite database to CSV

16 How to convert SQLIte database to JSON (with Python)

17 How to rename/ drop an SQLIte database