Skip to content

db.tables

Lists all tables for a given database.

db.tables [-ps] [driver=name] [database=name] [--verbose] [--quiet] [--qq] [--ui]

Example:

db.tables

grass.script.run_command("db.tables", driver="sqlite", database="$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db", flags=None, verbose=False, quiet=False, superquiet=False)

Example:

gs.run_command("db.tables")

Parameters

driver=name
    Name of database driver
    Allowed values: dbf, ogr, sqlite
    Default: sqlite
database=name
    Name of database
    Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
-p
    Print tables and exit
-s
    System tables instead of user tables
--help
    Print usage summary
--verbose
    Verbose module output
--quiet
    Quiet module output
--qq
    Very quiet module output
--ui
    Force launching GUI dialog

driver : str, optional
    Name of database driver
    Used as: input, dbdriver, name
    Allowed values: dbf, ogr, sqlite
    Default: sqlite
database : str, optional
    Name of database
    Used as: input, dbname, name
    Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db
flags : str, optional
    Allowed values: p, s
    p
        Print tables and exit
    s
        System tables instead of user tables
verbose: bool, optional
    Verbose module output
    Default: False
quiet: bool, optional
    Quiet module output
    Default: False
superquiet: bool, optional
    Very quiet module output
    Default: False

DESCRIPTION

db.tables lists all tables for a given database.

NOTE

If parameters for database connection are already set with db.connect, they are taken as default values and do not need to be specified each time.

EXAMPLES

List all tables if database connection is already set

db.tables -p

List all DBF tables

db.tables driver=dbf database=/grassdata/nc_spm_08/user1/PERMANENT/dbf

List all tables in SQLite database (note that this is the default setting)

db.tables -p driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'

SEE ALSO

db.columns, db.droptable, db.login, db.execute, GRASS SQL interface

AUTHOR

Unknown

SOURCE CODE

Available at: db.tables source code (history)
Latest change: Saturday Mar 01 15:13:00 2025 in commit 45f0c94