How do we design table without using table designer?

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 for MongoDB, Navicat Premium

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

In the diagram canvas, you can design a table without using Table Designer.

1. Select and click the table name and press Tab/Down Arrow to add/edit fields.
2. Navicat will predict field types according to field names you entered.
3. Enter * before the field name to recognize as primary key. e.g. *itemNo:int.
4. Enter : between field name and field type to custom field type, e.g. itemName:varchar(255).