All Collections
Database 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 week 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

    • 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

    • 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:

Did this answer your question?