Nov 18, 2025 · This article provides a summary of the different data types available in the SQL Server Database Engine.

In this tutorial, you will learn about SQL Server data types including numerics, character strings, binary strings, date & times, and other data types.

The data type of a column defines what value the column can hold: integer, character, money, date and time, binary, and so on. Each column in a database table is required to have a name and a data type.

Sep 25, 2020 · This article is overview of the different data types available in SQL Server that can used as a quick reference guide.

Feb 12, 2026 · This article breaks down all the data types available in SQL Server (as of SQL Server 2025), organized by category. Each type includes its max length, precision, scale, and whether it can …

The following is a list of datatypes available in SQL Server (Transact-SQL), which includes string, numeric, and date/time datatypes.

SQL Server Data Types The data types supported by the Microsoft SQL Server can be grouped into three main categories: string, numeric and date/time data types. String Data Types String data types …

Feb 27, 2025 · Learn about SQL Server data types, their categories, examples, and how to choose the right type for your data. Get tips on avoiding common mistakes and optimizing your database schema.

Data type synonyms are included in SQL Server for ISO compatibility. The following table lists the synonyms and the SQL Server system data types that they map to.

Also consider the maximum length of a table name (or column name) and the maximum size of an SQL statement - these limits vary considerably between products and versions.