The Tables page in Data Management (DMS) gives you a complete picture of any table — its physical structure, business context, and access controls — without leaving your SQL workflow. Table details cover three types of metadata:
Technical metadata: physical properties such as character set, row count, storage size, fields, indexes, data lineage, and data quality
Business metadata: tags, category, field descriptions, and usage notes that explain what the table is for
Management metadata: permissions, row-level access control, and the table owner
Prerequisites
Before you begin, make sure that:
The database instance is a relational database or a data warehouse. See Supported database types and features.
The instance is managed in Security Collaboration mode. See Control modes.
You meet at least one of the following access conditions:
You are a DMS administrator, a database administrator (DBA), or assigned the schema read-only role. See System roles.
You are the owner or DBA of the database instance. See Modify database instances.
You have query, change, or export permissions on the database instance or a table in it. See View owned permissions.
Open the Tables page
Log on to the DMS console V5.0, then use one of the following methods to open the Tables page.
From the Data Visualization tab (SQL Console)
In the top navigation bar, choose SQL Console > SQL Console.
In the Please select the database first dialog box, search for the database instance, select it, and click Confirm.
In the upper-right corner of the SQL Console tab, click the
icon in the extended feature section.Find the table, move the pointer over More in the Actions column, and select View Table Details.
The Details panel opens, and the Tables page loads.
From search
In the top navigation bar, click Home. In the search box, enter the table name.
In the search results, click the Table option, find the table, and click Details on the right.
Tables page reference
The Tables page is divided into sections. Each section covers a different aspect of the table.
| Section | What you can see and do |
|---|---|
| Table overview | View the table's core properties: Character Set, Rows, Capacity (MB), Environment, DB Information, Permission, Data Owner, Tag, Description, Business Description (up to 1,000 characters), and Category. |
| Basic Information | Three tabs covering structure and access control: Field Information, Index, and Row-level Control. See Field Information actions and Row-level control below. |
| Data Lineage | View how data flows to and from this table — table-to-table and field-to-field. Click  You can click the |
| Version Management | View schema versions on the Historical Versions tab. For each version, you can Preview script, run Table structure comparison, or restore the schema to an empty database using Structural recovery. See Synchronize schemas and Initialize empty databases. |
| Task Information | View task details — name, task ID, start time, duration, and end time — for any task orchestration jobs that write to this table. Click Code to open the task in the task orchestration page, or Log |
| Data Preview | View the first 50 data entries in the table. Requires query permissions on the table or its database instance. See View owned permissions. |
| Data quality | Create quality rules for the table. These rules can then be applied on the task orchestration page to validate table data. See Check the data quality. |
| Instructions for Use | Enter usage notes and additional context to help other users understand and work with the table. Supports Markdown. All users can view this content; only DMS administrators, DBAs, and the table owner can edit it. |
Field Information actions
The Field Information tab lists each field with its name, data type, description, sensitivity level, sensitivity level source, and business description.
If you are the table owner, a DMS administrator, or a DBA, you can edit the business description of any field: find the field and double-click the cell in the Business Description column.
The tab also provides the following actions:
| Action | Description |
|---|---|
| Generate a SELECT Statement | View the SELECT statement that queries all fields in the table. |
| Export Schema | Export the table schema as a data dictionary in Word, Excel, or PDF format. |
| Generate a DDL Statement | View the complete DDL statement used to create the table. |
| Security Level Adjustment | Change the sensitivity level for one or more fields. See Adjust the sensitivity level of one or more fields. |
| Code Generator | Generate code for the table in various formats. |
Row-level control
The Row-level Control tab lists control fields configured for the table. To view the details of a control field, click Control Value Details in the Actions column.
What's next
Use the asset category feature — organize tables using a category tree
Adjust the sensitivity level of one or more fields — manage data access control at the field level
Synchronize schemas — compare or promote schema versions across databases