How do we design table without using table designer?
updated at
Apply OS: Windows, macOS, Linux
Apply Navicat Product: Navicat Data Modeler
Apply Navicat Version No.: Version 1.x or above
In the diagram canvas, you can design a table without using Table Designer.
- Select and click the table name and press Tab/Down Arrow to add/edit fields.
- Navicat will predict field types according to field names you entered.
- Enter * before the field name to recognize as primary key. e.g. *itemNo:int.
- Enter : between field name and field type to custom field type, e.g. itemName:varchar(255).
Have more questions?
-
Support
-
About Us