Help Center/Admin Operations/Read the structure of a table in the Database Explorer
Admin Operations•Last updated: 2026-10-20•3 min read

Read the structure of a table in the Database Explorer

The "Structure" tab lists a table's columns, types, defaults, keys, indexes and constraints.

Have questions or need step-by-step guidance on this topic?

Ask AI Copilot

Step-by-Step Procedure

1

Select a table

In the Database Explorer click a table in the left list.

2

Open the tab

Click "Structure" (or press Alt+2).

3

Read the columns

The table shows #, Column, Type, Null, Default, Key (PK for primary key) and Notes (generated, identity, comments).

4

Read indexes and constraints

The "Indexes (n)" and "Constraints (n)" panels list each definition, or "None."

Expected Operational Outcome

You know the shape of the table before you query or edit it. The header marks protected or read-only tables.

Was this guide helpful?

Help us refine our platform documentation