Difference between revisions of "DISPLAY STRUCTURE"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
Helen.george (Talk | contribs) |
||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Display the structure of the active table | Display the structure of the active table | ||
| − | |||
==Syntax== | ==Syntax== | ||
| Line 10: | Line 9: | ||
[INDEX] | [INDEX] | ||
| − | [TO FILE <.txt filename> | (<expC>)] | + | [TO FILE <.txt filename> | (<expC>)] |
| − | + | ||
==See Also== | ==See Also== | ||
| − | [[COPY STRUCTURE]], [[COPY STRUCTURE EXTENDED | + | [[COPY STRUCTURE]], [[COPY STRUCTURE EXTENDED]], [[CREATE FROM]], [[DISPLAY DICTIONARY]], [[DISPLAY MEMORY]], [[DISPLAY STATUS]], [[LIST STRUCTURE]] |
| − | + | ||
==Description== | ==Description== | ||
| − | The DISPLAY STRUCTURE command displays the structure of the active table | + | The DISPLAY STRUCTURE command displays the structure of the active table. |
| − | + | {| class="wikitable" width="100%" | |
| − | {| class="wikitable" | + | !width="30%"|Keyword||Description |
| − | !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. | + | |valign="top"|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 display index tag information along with the structure details. | + | |valign="top"|INDEX||The INDEX keyword is used to display 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 | + | |valign="top"|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== | ==Example== | ||
| Line 41: | Line 34: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| − | [[Category: | + | [[Category:Databases]] |
| − | [[Category: | + | [[Category:NoSQL Commands]] |
Latest revision as of 09:50, 5 February 2013
Contents
Purpose
Display the structure of the active table
Syntax
DISPLAY STRUCTURE
[IN <alias>]
[INDEX]
[TO FILE <.txt filename> | (<expC>)]
See Also
COPY STRUCTURE, COPY STRUCTURE EXTENDED, CREATE FROM, DISPLAY DICTIONARY, DISPLAY MEMORY, DISPLAY STATUS, LIST STRUCTURE
Description
The DISPLAY 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 display 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. |
Example
use patrons display structure
