Displays the structure of a table file. The name of each field in the table is displayed with its type and width.

DISPLAY STRUCTURE [IN nWorkArea | cTableAlias]
   [TO PRINTER [PROMPT] | TO FILE FileName [ADDITIVE]] [NOCONSOLE]

Parameters

IN nWorkArea | cTableAlias

Displays the structure of the table in a work area other than the current work areas. nWorkArea specifies the work area number and cTableAlias specifies the table alias.

TO PRINTER [PROMPT]

Directs output from DISPLAY STRUCTURE to a printer.

You can include the optional PROMPT clause to display a dialog box before printing starts. In this dialog box, you can adjust printer settings, including the number of copies and page numbers to print. The printer settings that you can adjust depend on the currently installed printer driver. Place the PROMPT keyword immediately after TO PRINTER.

TO FILE FileName

Directs output from DISPLAY STRUCTURE to the file specified with FileName. If the file already exists and SET SAFETY is ON, you are asked if you want to overwrite the file.

ADDITIVE

Appends to the end of the named file. If you omit ADDITIVE, then the file is overwritten with the value of the expression.

NOCONSOLE

Suppresses output to the main Visual FoxPro window or to the active user-defined window.

Remarks

Example

In the following example, the customer table in the testdata database is opened. DISPLAY STRUCTURE is used to display the table structure.

	Copy Code
CLOSE DATABASES OPEN DATABASE (HOME(2) + 'Data\testdata') USE customer && Opens Customer table CLEAR DISPLAY STRUCTURE

See Also