Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Schema
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Uniques and Checks
Rules and Triggers
Privileges
Import/Export
Function
View
Tablespace
Cast
Language
Aggregate
Conversion
Domain
Trigger Function
Operator
Operator Class
Sequence
Type
Queries
Visual Query Builder
Data
Manage Users
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Adding Fields and Choosing Data Types
 
Add a field to a table
  1. Open the table in Design View
  2. Select the Fields tab
  3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
    To add a field at the end of the table, click Add Field from the Toolbar
  4. In the Name column enter the name of the field
  5. In the Type column click the arrow to select the field type or enter it manually

Create a field for text or memos

  1. Open the table in Design View
  2. Select the Fields tab
  3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
    To add a field at the end of the table, click Add Field from the Toolbar
  4. In the Name column enter the name of the field
  5. In the Type column click the arrow and select CHAR or VARCHAR for text fields or select TINYTEXT, TEXT, MEDIUMTEXT or LONGTEXT for memos

NOTE: The default length for CHAR and VARCHAR fields is 50. You can change this by setting the Length property.

Choosing Data Types

  1. Open the table in Design View
  2. Select the Fields tab
  3. To insert a field within the table, click in the row below where you want to add the field, and then click Insert Field from the Toolbar
    To add a field at the end of the table, click Add Field from the Toolbar
  4. In the Name column enter the name of the field
  5. In the Type column, choose data type

Name Aliases Description
bigint int8 signed eight-byte integer
bigserial serial8 autoincrementing eight-byte integer
bit [ (n) ]   fixed-length bit string
bit varying [ (n) ] varbit variable-length bit string
boolean bool logical Boolean (true/false)
box   rectangular box in the plane
bytea   binary data ("byte array")
character varying [ (n) ] varchar [ (n) ] variable-length character string
character [ (n) ] char [ (n) ] fixed-length character string
cidr   IPv4 or IPv6 network address
circle   circle in the plane
date   calendar date (year, month, day)
double precision float8 double precision floating-point number
inet   IPv4 or IPv6 host address
integer int, int4 signed four-byte integer
interval [ (p) ]   time span
line   infinite line in the plane
lseg   line segment in the plane
macaddr   MAC address
money   currency amount
numeric [ (p, s) ] decimal [ (p, s) ] exact numeric of selectable precision
path   geometric path in the plane
point   geometric point in the plane
polygon   closed geometric path in the plane
real float4 single precision floating-point number
smallint int2 signed two-byte integer
serial serial4 autoincrementing four-byte integer
text   variable-length character string
time [ (p) ] [ without time zone ]   time of day
time [ (p) ] with time zone timetz time of day, including time zone
timestamp [ (p) ] [ without time zone ]   date and time
timestamp [ (p) ] with time zone timestamptz date and time, including time zone