16.10 - ROW - Teradata Database

Teradata Database Support Utilities

Teradata Database
June 2017


The ROW command displays rows from one or more subtables. For a single subtable, ROW sets the context to those rows.


The online help lists the row options (/P, /S, /M, /L, /H) as /rowopt. You can type the options at the beginning or end of the command.

Positions to the physical rows or subtable requested. At least one physical row must be in the selected range. Nothing is displayed unless there is a problem.
Physical rows store one of several types of data, such as regular table row data or column partition data.
/S or /C
Counts the number of physical rows selected. This is the default for all subtables except the table header subtable.
/M or /I
Displays only the row header information (length, RowID, and flags).
/L or /R
Formats the row header and fields in the physical row. This option is the default for the table header subtable; however, this option is not the default formatted field display because the table header subtable has a special row format and requires special formatting.
Format the row header and display the entire physical row in hexadecimal, including the row header.
Specifies the subtable to display, which must include a typeandindex value. For detailed information, see Specifying a Subtable Identifier (tid).
A range of rows selected based upon row identification in the row header rather than the ordinal position within the subtable. For information on ridrange formatting, see Rows and Row Ranges.
The online help lists this option as rowspec [TO rowspec].

Usage Notes

The prompt for the ROW selector is shown below:

ROW ==>

The ROW command operates on subtables. In the Teradata Database, a subtable is a collection of physical rows, and a table is a collection of subtables. The physical rows of a particular subtable may store regular data rows, index rows, table header rows, column partition values, or other types of data. Therefore, you can use the ROW command to display rows from the primary data subtable, the table header subtable, a secondary index subtable, etc. For example, to obtain a formatted display of the table header, use ROW /L x y H, 0 1 where xand y make up the tablenumber which identifies the table, and H is the typeandindex value which identifies the table header subtable. For more information on identifying tables and subtables, see Specifying a Subtable Identifier (tid).

In addition to global and upper-level commands, the following lower-level commands are allowed at the ROW prompt:

  • DISPLAY (without ordinalrange)
  • DROP
  • NEXT
  • PREV