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

 

Navicat will predict field types according to field names you entered when you design table without using Table Designer.

INTEGER/int/int4/NUMBER

- suffix "id", "no" (if it is the first column, it will be predicted as a primary key)

- suffix "num"

- "qty", "number"

- exactly "age", "count"

DECIMAL(10,2)/decimal(10,2)/NUMBER/REAL/money

- suffix "price", "cost", "salary"

FLOAT/double/float8/NUMBER/REAL/float

- "size", "height", "width", "length", "weight", "speed", "distance"

DATE/datetime/date/TEXT/datetime2

- "date", "time"

VARCHAR(255)/varchar(255)/VARCHAR2(255)/TEXT

- other field names