Displaying SQL tables

SQL-DISPLAY-TABLE is a TCL command that displays the SQL structure for a D3 file. By default, only PARENT tables, created through SQL-CREATE-TABLE are displayed. To display all VIEW tables created for a particular D3 file, use the b or v option.

Syntax

SQL-DISPLAY-TABLE file_reference [(options] 

   file_reference ::=
      file_name
      | file_name, data_level
      | account_name, file_name,
      | account_name, file_name, data_level

Parameters

Parameter	Description
`options`	a	Displays all PARENT tables from the specified account, where file_reference is the account.
	b	Displays both PARENT and VIEW tables created for the D3 file specified by file_reference.
	n	No paging.
	p	Output to printer.
	t	Displays all PARENT tables created for the SQL table specified by `file_reference`.
	v	Displays all VIEW tables created for a the D3 file specified by `file_reference`.