SQLite

LIST DATABASE KEYS

Syntax

LIST DATABASE database_name KEYS

Privileges

PRAGMA

Description

The LIST DATABASE KEYS command returns a list of settings for the database_name database.

Return

A Rowset with the following columns:

  • key: database key
  • value:database value

Example

> LIST DATABASE mediastore.sqlite KEYS
-----|-------|
 key | value |
-----|-------|
 k1  | v1    |
-----|-------|
Previous
GET DATABASE