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).

Have more questions?
Submit Ticket