How do we design table without using table designer?

Apply OS: Windows, Mac, Linux

Apply Navicat Product: All

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

In model, you can design 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.
Have more questions? Submit a request


Article is closed for comments.