db.tables.1grass man page

db.tables — Lists all tables for a given database.

Keywords

database, attribute table

Synopsis

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

Flags

-p
Print tables and exit
-s
System tables instead of user tables
--help
Print usage summary
--verbose
Verbose module output
--quiet
Quiet module output
--ui
Force launching GUI dialog

Parameters

driver=name
Name of database driver
Options: mesql, pg, dbf, sqlite, odbc, ogr, mysql
Default: sqlite
database=name
Name of database
Default: $GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db

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 spcified 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

Last changed: $Date: 2014-11-28 10:58:18 +0100 (Fri, 28 Nov 2014) $

Main index | Database index | Topics index | Keywords index | Full index

© 2003-2016 GRASS Development Team, GRASS GIS 7.0.4 Reference Manual

Info

GRASS 7.0.4 Grass User's Manual