SqlDBM Help Center

All CollectionsDatabase Object and Feature Support

SQL Server Support Summary

SQL Server Support Summary

L

Written by Lena Kadantseva

Updated over a year 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: