Database Create Script Column Syntax Reference

Overview

Below is a list of the column syntax used for each data type in the supported script generators.

Microsoft SQL Server
boolean/bit	[column_name][bit] NULL
character	[column_name][tinyint] NULL
unsigned character	[column_name][smallint] NULL
short integer	[column_name][smallint] NULL
unsigned short integer	[column_name][int] NULL
long integer	[column_name][real] NULL
unsigned long integer	[column_name][float] NULL
single-precision float	[column_name][float] NULL
double-precision float	[column_name][float] NULL
string/text	[column_name][nvarchar](max_length) NULL
date	[column_name][datetime] NULL

Microsoft Access
boolean/bit	[column_name][YESNO] NULL
character	[column_name][SMALLINT] NULL
unsigned character	[column_name][SMALLINT] NULL
short integer	[column_name][SMALLINT] NULL
unsigned short integer	[column_name][INTEGER] NULL
long integer	[column_name][INTEGER] NULL
unsigned long integer	[column_name][FLOAT] NULL
single-precision float	[column_name][REAL] NULL
double-precision float	[column_name][FLOAT] NULL
string/text	[column_name][TEXT](max_length) NULL
date	[column_name][DATETIME] NULL

Oracle
boolean/bit	column_name NUMBER(1) NULL
character	column_name NUMBER(5) NULL
unsigned character	column_name NUMBER(5) NULL
short integer	column_name NUMBER(5) NULL
unsigned short integer	column_name NUMBER(11) NULL
long integer	column_name NUMBER(11) NULL
unsigned long integer	column_name BINARY_DOUBLE NULL
single-precision float	column_name BINARY_FLOAT NULL
double-precision float	column_name BINARY_DOUBLE NULL
string/text	column_name VARCHAR2(max_length) NULL
date	column_name DATE NULL

MySQL
boolean/bit	[column_name] BOOL NULL
character	[column_name] TINYINT NULL
unsigned character	[column_name] SMALLINT NULL
short integer	[column_name] SMALLINT NULL
unsigned short integer	[column_name] INT NULL
long integer	[column_name] INT NULL
unsigned long integer	[column_name] DOUBLE NULL
single-precision float	[column_name] FLOAT NULL
double-precision float	[column_name] DOUBLE NULL
string/text	[column_name] VARCHAR(max_length) NULL
date	[column_name] DATETIME NULL

Sybase
boolean/bit	[column_name] BIT NULL
character	[column_name] TINYINT NULL
unsigned character	[column_name] SMALLINT NULL
short integer	[column_name] SMALLINT NULL
unsigned short integer	[column_name] INTEGER NULL
long integer	[column_name] INTEGER NULL
unsigned long integer	[column_name] DOUBLE NULL
single-precision float	[column_name] REAL NULL
double-precision float	[column_name] DOUBLE NULL
string/text	[column_name] VARCHAR(max_length) NULL
date	[column_name] DATETIME NULL