DB Pilot icon DB Pilot
HomeFeaturesDocsChangelogPricing
Log in Download
  1. SQL Guides
  2. SQLite

SQLite Guides

Tips and tricks on using SQLite.

How to Create a Table

How to Create a Temporary Table

How to Drop a Table

How to Rename a Table

How to Add a Column

How to Drop a Column

How to Rename a Column

How to Query JSON

Composite Primary Keys

How to view a table's CREATE TABLE statement

Footer

DB Pilot icon DB Pilot

Product

  • Features
  • Pricing
  • Download

Links

  • PostgreSQL GUI Client
  • CockroachDB GUI Client
  • MySQL GUI Client
  • SQLite GUI Client
  • DuckDB GUI Client

About

  • Privacy
  • Terms

Resources

  • Docs
  • Changelog
  • Blog
  • SQL Guides

Subscribe to our newsletter

Get the latest news, articles, and resources delivered to your inbox.

[email protected]

© 2025 Maravista Software LLC. All rights reserved