How to view table structure of a table?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: Version 8.x or above

Windows & Linux 11.2 or below

Right click the table and select Table Information/Object Information. Then, select the DDL tab. The table definition will be shown.

macOS 11.2 or below

Select the table and choose View > Object Information/Show Object Information. Then, select the DDL tab. The table definition will be shown.

Version 12 or above

Select the table and click the DDL icon in the Information Pane. If the Information Pane is hidden, select View > Information Pane > Show Information Pane.