Skip to main content

Open Table

Open Table

If you select a table or view on the left side of the Management Portal SQL interface, the Catalog Details for that tableor view are displayed. The Open Table link at the top of the page also becomes active. Open Table displays the actual data in the table (or accessed via the view). The data is shown in Display format.

By default, the first 100 rows of data are displayed; this default is modifiable by setting the Number of rows to load when table is opened in the Catalog Details tab Table Info. If there are more rows in the table than this number of rows to load value, the More data... indicator is shown at the bottom of the data display. If there are fewer rows in the table than this number of rows to load value, the Complete indicator is shown at the bottom of the data display.

A column of data type %Stream.GlobalCharacterOpens in a new tab displays the actual data (up to 100 characters) as a string. Additional data beyond the first 100 characters is indicated by an ellipsis (...).

A column of data type %Stream.GlobalBinaryOpens in a new tab displays as <binary>.

FeedbackOpens in a new tab