This article summarizes the features, objects, properties, and data types that are available for Azure Synapse projects.
Features
Objects and properties
-
-
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
-
-
-
Data type (see summary of types below)
-
(NOT) NULL
-
Default
-
Name
-
-
Collation
-
Comment/Description
-
-
-
Materialized
-
Comment/Description
-
-
External Tables
-
Constraints
-
Location
-
Data source
-
File format
-
Reject type
-
Value
-
Percentage
-
-
Rejected row location
-
Comment/Description
-
Post Script
-
-
-
Overloading parameters
-
Comment/Description
-
-
-
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
-