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?
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