<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>GRASS GIS: db.describe</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.describe</b></em> - Describes a table in detail.
<h2>KEYWORDS</h2>
database, SQL
<h2>SYNOPSIS</h2>
<b>db.describe</b><br>
<b>db.describe help</b><br>
<b>db.describe</b> [-<b>ct</b>] <b>table</b>=<em>name</em> [<b>driver</b>=<em>name</em>] [<b>database</b>=<em>name</em>] [--<b>verbose</b>] [--<b>quiet</b>]
<h3>Flags:</h3>
<DL>
<DT><b>-c</b></DT>
<DD>Print column names only instead of full column descriptions</DD>
<DT><b>-t</b></DT>
<DD>Print table structure</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>table</b>=<em>name</em></DT>
<DD>Table name</DD>
<DT><b>driver</b>=<em>name</em></DT>
<DD>Driver name</DD>
<DD>Options: <em>odbc,dbf</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.describe</em> displays table information. If parameter <b>-c</b> is used
only column names instead of full column descriptions is given.
<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>EXAMPLE</h2>
<div class="code"><pre>
db.describe -c table=roads database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' \
driver=dbf
ncols:2
Column 1:cat:INTEGER:11
Column 2:label:CHARACTER:43
</pre></div>
<div class="code"><pre>
db.describe table=roads database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' \
driver=dbf
table:roads
description:
insert:yes
delete:yes
ncols:2
column:cat
description:
type:INTEGER
len:11
scale:0
precision:10
default:
nullok:yes
select:yes
update:yes
[...]
</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.execute.html">db.execute</a>,
<a HREF="db.login.html">db.login</a>,
<a HREF="db.tables.html">db.tables</a>,
<a HREF="sql.html">GRASS SQL interface</a></em>
<h2>AUTHOR</h2>
Radim Blazek, ITC-Irst, Trento, Italy
<p><i>Last changed: $Date: 2007-04-07 18:18:51 +0200 (Sat, 07 Apr 2007) $</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>
