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

 

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

  1. Select and click the table name and press Tab or Down Arrow to add or 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