Azure Synapse Support Summary

SqlDBM Support

May 30, 2025 17:18 Updated

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

Features

Objects and properties

Schemas
Tables
- Constraints
  - PK
  - AK (UNIQUE)
- Clustering columnstore index
  - Columns
  - Destribution options
    - Hash
    - Roundrobin
    - Replicate
- Heap
  - Destribution options
    - Hash
    - Roundrobin
    - Replicate
- Clustered index
  - Position
  - ASC / DESC
  - Destribution options
    - Hash
    - Roundrobin
    - Replicate
- Partitioning
  - value
  - Left / right
- Index
- Comment/Description
- Post Script
Columns
- Data type (see summary of types below)
- (NOT) NULL
- Default
  - Name
- Collation
- Comment/Description
Views
- Materialized
- Comment/Description
External Tables
- Constraints
  - PK
  - AK (UNIQUE)
- Location
- Data source
- File format
- Reject type
  - Value
  - Percentage
- Rejected row location
- Comment/Description
- Post Script
Functions/UDFs
- Overloading parameters
- Comment/Description
Procedures
- Overloading parameters
- Comment/Description

Data types

Numeric Data Types
- DECIMAL
- NUMERIC
- INT
- TINYINT
- SMALLINT
- BIGINT
- BIT
- MONEY
- SMALLMONEY
- FLOAT
- REAL
String & Binary Data Types
- VARCHAR
- NCHAR
- NVARCAHR
- CHAR
- TEXT
- BINARY
- VARBINARY
- IMAGE
Date & Time Data Types
- DATE
- DATETIME
- DATETIME2
- DATETIMEOFFSET
- SMALLDATETIME
- TIME

See also: