SQL Server Data Types
SQL Server data types, with descriptions, size limits, and storage requirements.
Download optionsThe records
The 10 most recently added of 35 records · Select a column heading to sort.
| ID | Data type | Description | Max size | Storage |
|---|---|---|---|---|
| 35 | table | Stores a result-set for later processing | ||
| 34 | cursor | Stores a reference to a cursor used for database operations | ||
| 33 | xml | Stores XML formatted data. Maximum 2GB | ||
| 32 | uniqueidentifier | Stores a globally unique identifier (GUID) | ||
| 31 | sql_variant | Stores up to 8,000 bytes of data of various data types, except text, ntext, and timestamp | ||
| 30 | timestamp | Stores a unique number that gets updated every time a row gets created or modified. The timestamp value is based upon an internal clock and does not correspond to real time. Each table may have only one timestamp variable | ||
| 29 | datetimeoffset | The same as datetime2 with the addition of a time zone offset | 8-10 bytes | |
| 28 | time | Store a time only to an accuracy of 100 nanoseconds | 3-5 bytes | |
| 27 | date | Store a date only. From January 1, 0001 to December 31, 9999 | 3 bytes | |
| 26 | smalldatetime | From January 1, 1900 to June 6, 2079 with an accuracy of 1 minute | 4 bytes |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
A complete download includes all 35 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/sqlserverdatatypesChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.