LIST STRUCTURE
From Lianjapedia
Contents
Purpose
Display the structure of the active table
Syntax
LIST STRUCTURE [IN <alias>] [INDEX] [TO FILE <.txt filename> | (<expC>)]
See Also
COPY STRUCTURE, COPY STRUCTURE EXTENDED, CREATE FROM, DISPLAY DICTIONARY, DISPLAY MEMORY, DISPLAY STATUS, DISPLAY STRUCTURE, LIST DICTIONARY
Description
The LIST STRUCTURE command displays the structure of the active table.
Keyword | Description |
---|---|
IN <alias> | The IN <alias> clause is used to display the structure of an open table in a workarea that is not currently selected. Alias names may be assigned to tables with the USE command, or default to the table basename. |
INDEX | The INDEX keyword is used to list index tag information along with the structure details. |
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. |
From Lianja v6.0, if the table is a Virtual Table, the following information is also displayed:
- Connection String (connstr)
- Database Type (dbtype)
- Properties
- Base Table (basetable)
- SQL Command
- Primary Key (primarykey)
- Update Field List (updatefieldlist)
- Named Parameters (namedparameters)
Example
use patrons list structure