All Collections
Database Object and Feature Support
SQL Server Support Summary
SQL Server Support Summary
L
Written by Lena Kadantseva
Updated over a week ago

This article summarizes the features, objects, properties, and data types that are available for SQL Server projects.

The objects and properties listed below are compatible with all versions of SQL Server:

  • SQL Server 2012

  • SQL Server 2014

  • SQL Server 2016/2017

  • SQL Server 2019/2022

Objects and properties

  • Schemas

  • Tables

    • Constraints

      • PK

        • Clustered / Nonclustered

        • ASC / DESC

      • AK (UNIQUE)

        • Clustered / Nonclustered

        • Expression

        • ASC / DESC

      • FK

      • CHECK

        • Expression

        • Not for replication

        • NoCheck

    • Comment/Description

    • Post Script

  • Columns

    • Data type (see summary of types below)

    • (NOT) NULL

    • Default

    • Identity

      • Start

      • Increment

    • Computed

      • Persisted

    • Collation

    • Comment/Description

  • Views

    • Materialized

    • Comment/Description

  • Functions/UDFs

    • Overloading parameters

    • Comment/Description

  • Procedures

    • Overloading parameters

    • Comment/Description

Data types

  • Numeric Data Types

    • DECIMAL

    • NUMERIC

    • INT

    • TINYINT

    • SMALLINT

    • BIGINT

    • MONEY

    • SMALLMONEY

    • BIT

    • FLOAT

    • REAL

  • String & Binary Data Types

    • VARCHAR

    • NVARCHAR

    • CHAR

    • NCHAR

    • NTEXT

    • TEXT

    • BINARY

    • VARBINARY

    • IMAGE

  • Date & Time Data Types

    • DATE

    • DATETIME

    • DATETIME2

    • DATETIMEOFFSET

    • SMALLDATETIME

    • TIME

  • Geospatial data types

    • GEOGRAPHY

    • GEOMETRY

See also:

Did this answer your question?