Geografic-Information-System/db/db.describe/db.describe.html

<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>EXAMPLES</h2>

<em>List column descriptions of table in SQLite database (note that this
is the default setting)</em><br>

<div class="code"><pre>
db.describe driver=sqlite table=hospitals \
   database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite/sqlite.db'

# or simply
db.describe myarchsites
</pre></div>

<h3>DBF example</h3>
<div class="code"><pre>
db.describe -c table=hospitals database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' \
            driver=dbf
ncols: 16
nrows: 160
Column 1: cat:INTEGER:11
Column 2: OBJECTID:INTEGER:11
Column 3: AREA:DOUBLE PRECISION:20
[...]
</pre></div>

<div class="code"><pre>
db.describe table=hospitals database='$GISDBASE/$LOCATION_NAME/PERMANENT/dbf/' \
            driver=dbf
table:hospitals
description:
insert:yes
delete:yes
ncols:16
nrows:160

column:cat
description:
type:INTEGER
len:11
scale:0
precision:10
default:
nullok:yes
select:yes
update:yes

column:OBJECTID
description:
type:INTEGER
[...]
</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$</i>