LIST STRUCTURE

From Lianjapedia
Jump to: navigation, search

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