SqlDBM Help Center

All CollectionsDatabase Object and Feature Support

Azure Synapse Support Summary

Azure Synapse Support Summary

SQL Server and Azure Synapse object and data type support summary

S

Written by Serge Gershkovich

Updated over a year ago

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: