Limitations
Invalid schema name (containing \ or /)
ALTER TABLE (ADD/DROP and all ALTER COLUMN except ADD/DROP MASKED)
BULK INSERT
CREATE ROLE
CREATE USER
FOR BROWSE/XML/JSON
OPENROWSET
SET TRANSACTION ISOLATION LEVEL
SET ROWCOUNT. Note that in cases where we can emulate it the error is not reported.
SET RESULT_SET_CACHING
SP_SHOWSPACEUSED
MULTI-COLUMN STATISTIC
RECURSIVE QUERY
PREDICT
$PARTITION
Unsupported functions - the ones returning errors in Fabric and some that work but return invalid value
SCALAR function
XML methods
system views (sys.sequences, sys.dm_pdw_*)
Last updated