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