<div>
<div class="content wysiwyg-content">
I have a data modeler tool without bigint data type. But it has the following data types.<br />
<br />
int<br />
numeric<br />
decimal.<br />
real<br />
smallint<br />
tinyint<br />
varchar<br />
....<br />
<br />
I am creating a table and defining a field which should be bigint<br />
<br />
I want to know which one is the same or the closest to bigint here?<br />
<br />
The data model is for MS SQL table.
</div>
</div>


I have a data modeler tool without bigint data type. But it has the following data types.

int
numeric
decimal.
real
smallint
tinyint
varchar
....

I am creating a table and defining a field which should be bigint

I want to know which one is the same or the closest to bigint here?

The data model is for MS SQL table.

bigint

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

A modeling language is any artificial language that can be used to express information or knowledge or systems in a structure that is defined by a consistent set of rules. The rules are used for interpretation of the meaning of components in the structure; modeling languages can be either graphical or textual. The Unified Modeling Language (UML) is a general-purpose, developmental, modeling language in the field of software engineering, that is intended to provide a standard way to visualize the design of a system.