Difference between revisions of "DISPLAY DATABASE"
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 12: | Line 12: | ||
* Database Name, e.g. southwind | * Database Name, e.g. southwind | ||
− | * Database Path, e.g. | + | * Database Path, e.g. C:\lianja\data\southwind\ |
and for each table in the database the equivalent of DISPLAY STRUCTURE INDEX followed by DISPLAY DICTIONARY: | and for each table in the database the equivalent of DISPLAY STRUCTURE INDEX followed by DISPLAY DICTIONARY: | ||
Line 32: | Line 32: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | |||
open database southwind | open database southwind | ||
display database to file sw_info | display database to file sw_info |
Latest revision as of 13:18, 19 May 2014
Purpose
Display information about the active database
Syntax
DISPLAY DATABASE [TO FILE <.txt filename> | (<expC>)]
See Also
ADATABASES(), ALTER INDEX, ALTER TABLE, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, COPY DATABASE, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DBUSED(), DISPLAY INDEXES, DISPLAY SCHEMAS, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, SET EXCLUSIVE, USE
Description
The DISPLAY DATABASE command is used to display information about the currently active database.
- Database Name, e.g. southwind
- Database Path, e.g. C:\lianja\data\southwind\
and for each table in the database the equivalent of DISPLAY STRUCTURE INDEX followed by DISPLAY DICTIONARY:
- Table file name
- Number of records
- Date of creation
- Date of last update
- Encryption status
- Field names, types, sizes and description
- Total record length
- Production DBX file name
- Index tag names, keys, types and lengths
- Dictionary information
TO <file>
The display output will be sent to the specified file. The filename can be substituted with a <expC>, enclosed in round brackets, which returns a valid filename. If no file extension is specified, then ".txt" will be used.
Example
open database southwind display database to file sw_info