SQL Server Support Summary

SqlDBM Support

August 21, 2025 13:21 Updated

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, including:

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
- Indexes
  - Index
    - Where expression
    - Clustered
    - Members
    - Description
  - PK Index
    - Where expression
    - Clustered
    - Members
    - Description
  - FK Index
    - Where expression
    - Clustered
    - Members
    - Description
  - Unique Index
    - Where expression
    - Clustered
    - Members
    - Description
  - Fulltext Index
    - Where expression
    - Members
    - Description
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: