How do we design table without using table designer?

Apply OS: Windows, Mac, Linux

Apply Navicat Product: Navicat Data Modeler

Apply Navicat Version No.: Version 1.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

0 Comments

Article is closed for comments.