Aktuelle Version vom 6. April 2024, 20:33 Uhr

This article contains basic knowledge, commands and how to's for SQLite.

SQLite is the most used database engine in the world.

General Information

Open database.sqlite with sqlite CLI client:

sqlite database.sqlite

Within SQLite CLI interface


Command	Description
`.help`	Help
`.exit`	Quit
`.tables`	List tables in database
`.schema [<tablename>]`	Show database table description, optionally for a given table name

@@ Zeile 7: / Zeile 7: @@
   sqlite database.sqlite
 Within SQLite CLI interface
- .help                  # Help
+{|
- .exit                  # Quit
+|+
- .tables                # List all tables
+!Command
+!Description
+|-
+|<code>.help</code>
+|Help
+|-
+|<code>.exit</code>
+|Quit
+|-
+|<code>.tables</code>
+|List tables in database
+|-
+|<code>.schema [<tablename>]</code>
+|Show database table description, optionally for a given table name
+|}
 [[Kategorie:SQL]]