The SQL type bigint
is typically no shorter than a 64 big signed integer (-9223372036854775808 to 9223372036854775807).
CREATE TABLE table_name (
column_name BIGINT
)
Note that the SQL language has no unsigned
modifier (see: domain
, check
).
Related
Bigint
in other places:cast
target.Other integer types:
smallint
,integer
/int
Restricting the value range (e.g. unsigned):
domain
,check
SQL types for decimal numbers:
numeric
,decimal
,decfloat
Numeric types with approximate arithmetic:
float
,real
,double precision
Product specific integer types:
tinyint
,mediumint
,int2
,int4
,int8
,int64
,unsigned
,signed
Normative References
The type bigint
is defined in ISO/IEC 9075:2016-2 (T071) with an implementation defined precision.0 The corresponding data type of the C programming language is long long
,1 which corresponds to the above mentioned value range.2