Viewing a Table - basics
To view details about a database table:
- Expand nodes in the Databases tab tree under the connection node until you find the table,
- Double-click on the table node to open its Object View tab.
The Object View has a number of sub tabs. Exactly which sub tabs are available depends on the database type, but these are common for all types:
| Subtab | Description |
|---|---|
| Info | Brief information about the table. |
| Columns | Information about all table columns, e.g. data types and sizes. |
| Data | Then table data. Here you can view and edit the data. |
| Row Count | The number of rows in the table. |
| Primary Key | Information about the table's primary key columns, if any. |
| Indexes | Information about the table's indexes, if any. |
| Grants | Information about granted privileges for the table. |
| DDL | Shows the CREATE statement for the table. |
| References | Shows declared primary/foreign key relationships to other tables. Please read more in Viewing Table Relationships. |
| Navigator | Navigate through the declared relationships. Please read more in Navigating Table Relationships. |