Print Table Command

Use the Print Table command to print information about the attributes of a specific table, including the number and characteristics of each table column.

Syntax

print table NAME [user USER_NAME | system][SELECT];
  • NAME is the name of the table to be printed.
  • USER_NAME refers to a person, group, role, or association.
  • system refers to a table that is available for system-wide use, and not associated with the session context.
  • SELECT specifies a subset of the list contents.

This command searches the list of defined tables. If the name is found, that table information is printed. If the name is not found, an error message is displayed. For example, to print details about the table named “DescNote,” enter the following:

print table "DescNote";

The following is sample output:

MQL<28>print table 'DescNote';
table           DescNoteRes
 inactive 

#100000 column
	label      Description
	businessobject description
	size       11 2	
 minsize    0 0
	autoheight true
	autowidth  true
	editable   true
	hidden     false
	sorttype   none
	user       all 

#100001 column	label      Notes
	businessobject attribute[Notes]
	size       10 2
	minsize    0 0
	autoheight true
	autowidth  true
	editable   true
	hidden     false
	sorttype   none
	user       all
 nothidden
 created Wed Oct 31, 2001 2:57:09 PM EST 
 modified Wed Feb 20, 2002 2:47:56 PM EST

Since tables have additional uses in support of dynamic UI modeling, the MQL print command suppresses the output of data that is not used. For example, if you print a table that is defined as a system object used for Web applications, the following selects will not be printed:

size, minsize, scale, font, minwidth, minheight, absolutex, absolutey, xlocation, ylocation, width, and height.

Conversely, when printing non-Web tables, parameters used only for Web-based tables are suppressed from the output:

href, alt, range, update, and settings