<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>GRASS GIS: db.tables</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link rel="stylesheet" href="grassdocs.css" type="text/css"> </head> <body bgcolor="white"> <img src="grass_logo.png" alt="GRASS logo"><hr align=center size=6 noshade> <h2>NAME</h2> <em><b>db.tables</b></em> - Lists all tables for a given database. <h2>KEYWORDS</h2> database, SQL <h2>SYNOPSIS</h2> <b>db.tables</b><br> <b>db.tables help</b><br> <b>db.tables</b> [-<b>ps</b>] [<b>driver</b>=<em>name</em>] [<b>database</b>=<em>name</em>] [--<b>verbose</b>] [--<b>quiet</b>] <h3>Flags:</h3> <DL> <DT><b>-p</b></DT> <DD>Print tables and exit</DD> <DT><b>-s</b></DT> <DD>System tables instead of user tables</DD> <DT><b>--verbose</b></DT> <DD>Verbose module output</DD> <DT><b>--quiet</b></DT> <DD>Quiet module output</DD> </DL> <h3>Parameters:</h3> <DL> <DT><b>driver</b>=<em>name</em></DT> <DD>Driver name</DD> <DD>Options: <em>odbc,dbf,pg</em></DD> <DD>Default: <em>dbf</em></DD> <DT><b>database</b>=<em>name</em></DT> <DD>Database name</DD> <DD>Default: <em>$GISDBASE/$LOCATION_NAME/$MAPSET/dbf/</em></DD> </DL> <h2>DESCRIPTION</h2> <em>db.tables</em> lists all tables for a given database. <h2>NOTE</h2> If parameters for database connection are already set with <a HREF="db.connect.html">db.connect</a>, they are taken as default values and do not need to be spcified each time. <h2>EXAMPLES</h2> <em>List all tables if database connection is already set</em><br> <div class="code"><pre> db.tables -p </pre></div> <p> <em>List all tables of existing dbf database</em><br> <div class="code"><pre> db.tables driver=dbf database=/home/user/grassdata/fire/PERMANENT/dbf </pre></div> <h2>SEE ALSO</h2> <em><a HREF="db.columns.html">db.columns</a>, <a HREF="db.droptable.html">db.droptable</a>, <a HREF="db.login.html">db.login</a>, <a HREF="db.execute.html">db.execute</a>, <a HREF="sql.html">GRASS SQL interface</a></em> <h2>AUTHOR</h2> ? <p><i>Last changed: $Date: 2005-12-10 18:49:50 +0100 (Sat, 10 Dec 2005) $</i> <HR> <P><a href="index.html">Main index</a> - <a href="database.html">database index</a> - <a href="full_index.html">Full index</a></P> <P>© 2003-2008 <a href="http://grass.osgeo.org">GRASS Development Team</a></p> </body> </html>