Wiki Admin

hana.template

Export as HTML Export as PDF Export as DOCX
Edit

Documentation: hana.template

Repository Data Type Attributes HANA
ansidate (ingres) nullable=0 date
ansidate nullable=0 date
bfile nullable=0 blob
bigdatetime timeprec=6
nullable=0 		timestamp
bigint unsigned bytelen=8
nullable=0 		decimal(20)
bigint bytelen=8
nullable=0 		bigint
bigtime timeprec=6
nullable=0 		time
binary bytelen=10
nullable=0 		binary(10)
binary_double bytelen=8
nullable=0 		double
binary_float bytelen=4
nullable=0 		real
binary decimal prec=9
scale=3
nullable=0 		decimal(9,3)
binary decimal prec=6
scale=2
nullable=0 		decimal(6,2)
bit (mysql) bitlen=32
nullable=0 		varchar(32)
bit bytelen=1
nullable=0 		boolean
blob nullable=0 blob
bool bytelen=1
nullable=0 		boolean
boolean bytelen=1
nullable=0 		boolean
byte varying bytelen=10
nullable=0 		varbinary(10)
byte bytelen=10
nullable=0 		binary(10)
byteint bytelen=1
nullable=0 		smallint
c bytelen=10
encoding=UTF-8
nullable=0 		char(60)
char bytelen=10
encoding=UTF-8
nullable=0 		char(60)
char bytelen=4000
encoding=UTF-8
nullable=0 		clob
char bytelen=8000
encoding=UTF-8
nullable=0 		clob
char bytelen=40
charlen=10
encoding=UTF-8
nullable=0 		char(60)
char bytelen=10
encoding=WINDOWS-1252
nullable=0 		char(20)
char (oracle) bytelen=10
encoding=UTF-8
nullable=0 		char(60)
char (oracle) bytelen=2000
encoding=UTF-8
nullable=0 		clob
char (oracle) bytelen=40
charlen=10
encoding=UTF-8
nullable=0 		char(60)
char (oracle) bytelen=10
encoding=WINDOWS-1252
nullable=0 		char(20)
clob encoding=UTF-8
nullable=0 		clob
datalink bytelen=800
charlen=200
encoding=UTF-8
nullable=0 		varchar(1200)
date nullable=0 timestamp
date (hana) nullable=0 date
date (mysql) nullable=0 date
date (sybase) nullable=0 date
datetime (bigquery) timeprec=0
nullable=0 		timestamp
datetime (mysql) timeprec=0
nullable=0 		timestamp
datetime (sybase) nullable=0 timestamp
datetime nullable=0 timestamp
datetime2 timeprec=0
nullable=0 		timestamp
datetimeoffset timeprec=0
nullable=0 		timestamp
db2 rowid bytelen=40
nullable=0 		varchar(80)
db2 timestamp with time zone timeprec=0
nullable=0 		timestamp
db2 xml encoding=UTF-8
nullable=0 		clob
dbclob nullable=0 nclob
decfloat prec=16
nullable=0 		varchar(42)
decfloat prec=34
nullable=0 		varchar(42)
decimal prec=10
scale=3
nullable=0 		decimal(10,3)
decimal prec=6
nullable=0 		decimal(6)
double bytelen=8
nullable=0 		double
epoch timeprec=0
nullable=0 		timestamp
float bytelen=8
nullable=0 		double
float4 bytelen=4
nullable=0 		real
float8 bytelen=8
nullable=0 		double
float64 bytelen=8
nullable=0 		double
graphic charlen=10
nullable=0 		nchar(10)
hierarchyid bytelen=892
nullable=0 		varchar(4000)
image nullable=0 blob
image (sybase) nullable=0 blob
ingresdate nullable=0 timestamp
int unsigned bytelen=4
nullable=0 		bigint
int bytelen=4
nullable=0 		integer
integer bytelen=4
nullable=0 		integer
integer1 bytelen=1
nullable=0 		smallint
integer2 bytelen=2
nullable=0 		smallint
integer4 bytelen=4
nullable=0 		integer
integer8 bytelen=8
nullable=0 		bigint
int64 bytelen=8
nullable=0 		bigint
interval day to second (ingres) timeprec=0
nullable=0 		timestamp
interval day to second timeprec=0
dayprec=0
nullable=0 		timestamp
interval month to second timeprec=0
nullable=0 		timestamp
interval year to month (ingres) nullable=0 timestamp
interval year to month yearprec=0
nullable=0 		timestamp
json encoding=UTF-8
nullable=0 		clob
jsonb encoding=UTF-8
nullable=0 		clob
long byte nullable=0 blob
long char encoding=UTF-8
nullable=0 		clob
long nvarchar (db2) nullable=0 nclob
long nvarchar nullable=0 nclob
long raw nullable=0 blob
long varbinary nullable=0 blob
long varchar (db2) encoding=UTF-8
nullable=0 		clob
long varchar encoding=UTF-8
nullable=0 		clob
long encoding=UTF-8
nullable=0 		clob
mediumint unsigned bytelen=3
nullable=0 		integer
mediumint bytelen=3
nullable=0 		integer
money (ingres) nullable=0 decimal(14,2)
money nullable=0 decimal(19,4)
nchar charlen=10
nullable=0 		nchar(10)
nchar (oracle) bytelen=20
charlen=10
nullable=0 		nchar(10)
nclob nullable=0 nclob
ntext nullable=0 nclob
number nullable=0 decimal
number prec=10
scale=-127
nullable=0 		double
number prec=10
scale=3
nullable=0 		decimal(10,3)
number prec=26
nullable=0 		decimal(26)
number prec=6
nullable=0 		decimal(6)
numeric (db2i) prec=10
scale=3
nullable=0 		decimal(10,3)
numeric (db2i) prec=6
nullable=0 		decimal(6)
numeric prec=10
scale=3
nullable=0 		decimal(10,3)
numeric prec=26
nullable=0 		decimal(26)
numeric prec=6
nullable=0 		decimal(6)
nvarchar charlen=10
nullable=0 		nvarchar(10)
nvarchar(max) nullable=0 nclob
nvarchar2 charlen=10
nullable=0 		nvarchar(10)
postgres date nullable=0 date
postgres time timeprec=6
nullable=0 		time
postgres timestamp with time zone timeprec=0
nullable=0 		timestamp
postgres timestamp timeprec=0
nullable=0 		timestamp
raw bytelen=10
nullable=0 		varbinary(10)
real bytelen=4
nullable=0 		real
rowid bytelen=18
charlen=18
encoding=US-ASCII
nullable=0 		char(18)
rowversion bytelen=10
nullable=0 		binary(10)
smalldatetime nullable=0 timestamp
smallint unsigned bytelen=2
nullable=0 		integer
smallint bytelen=2
nullable=0 		smallint
smallmoney nullable=0 decimal(10,4)
text (ingres) bytelen=10
encoding=UTF-8
nullable=0 		varchar(60)
text (sqlserver) encoding=WINDOWS-1252
nullable=0 		clob
text(sybase) encoding=UTF-8
nullable=0 		clob
time (mysql) timeprec=0
nullable=0 		time
time (hana) nullable=0 time
time (sybase) nullable=0 time
time with local time zone timeprec=0
nullable=0 		time
time with time zone timeprec=0
nullable=0 		time
time timeprec=0
nullable=0 		time
time timeprec=3
nullable=0 		time
time2 nullable=0 time
timestamp (bigquery) timeprec=0
nullable=0 		timestamp
timestamp (databricks) timeprec=0
nullable=0 		timestamp
timestamp (db2) timeprec=0
nullable=0 		timestamp
timestamp (hana) timeprec=0
nullable=0 		timestamp
timestamp (ingres) timeprec=0
nullable=0 		timestamp
timestamp (mysql) timeprec=0
nullable=0 		timestamp
timestamp (oracle) timeprec=0
nullable=0 		timestamp
timestamp (sqlserver) bytelen=10
nullable=0 		binary(10)
timestamp (sybase) bytelen=10
nullable=0 		varbinary(10)
timestamp with local time zone timeprec=0
nullable=0 		timestamp
timestamp with local tz (oracle) timeprec=0
nullable=0 		timestamp
timestamp with time zone timeprec=0
nullable=0 		timestamp
timestamp with tz (oracle) timeprec=0
nullable=0 		timestamp
timestamp timeprec=0
nullable=0 		timestamp
tinyint signed bytelen=1
nullable=0 		smallint
tinyint unsigned bytelen=1
nullable=0 		tinyint
tinyint bytelen=1
nullable=0 		tinyint
uniqueidentifier bytelen=16
nullable=0 		binary(16)
unitext nullable=0 nclob
univarchar charlen=10
nullable=0 		nvarchar(10)
unsigned bigint bytelen=8
nullable=0 		decimal(20)
unsigned int bytelen=4
nullable=0 		bigint
unsigned smallint bytelen=2
nullable=0 		integer
urowid bytelen=100
charlen=100
encoding=US-ASCII
nullable=0 		varchar(100)
varbinary bytelen=10
nullable=0 		varbinary(10)
varbinary (sybase) bytelen=10
nullable=0 		varbinary(10)
varbinary(max) nullable=0 blob
varbyte bytelen=10
nullable=0 		varbinary(10)
varchar bytelen=10
encoding=UTF-8
nullable=0 		varchar(60)
varchar bytelen=8000
encoding=UTF-8
nullable=0 		clob
varchar bytelen=40
charlen=10
encoding=UTF-8
nullable=0 		varchar(60)
varchar bytelen=10
encoding=WINDOWS-1252
nullable=0 		varchar(20)
varchar (sybase) bytelen=10
encoding=UTF-8
nullable=0 		varchar(60)
varchar (sybase) bytelen=8000
encoding=UTF-8
nullable=0 		clob
varchar (sybase) bytelen=40
charlen=10
encoding=UTF-8
nullable=0 		varchar(60)
varchar (sybase) bytelen=10
encoding=WINDOWS-1252
nullable=0 		varchar(20)
varchar(max) encoding=WINDOWS-1252
nullable=0 		clob
varchar2 bytelen=10
encoding=UTF-8
nullable=0 		varchar(60)
varchar2 bytelen=40
charlen=10
encoding=UTF-8
nullable=0 		varchar(60)
varchar2 bytelen=10
encoding=WINDOWS-1252
nullable=0 		varchar(20)
vargraphic charlen=10
nullable=0 		nvarchar(10)
variant encoding=UTF-8
nullable=0 		clob
xml nullable=0 nclob
year (mysql) nullable=0 smallint