fabric-databaselisted

# Fabric SQL Database Fabric SQL Database is an Azure SQL Database hosted within a Fabric workspace. It is a **completely different engine** from Fabric Warehouse and does NOT share the Warehouse's restrictions. ## Key Differences from Fabric Warehouse | Feature | Fabric Warehouse | Fabric SQL Database | |---|---|---| | Engine | Distributed Synapse DW | Azure SQL Database | | `nvarchar`, `datetime`, `money` | Not supported | Fully supported | | Triggers | Not supported | Fully supported | | MERGE | Preview only | Fully supported | | ALTER COLUMN | Not supported | Fully supported | | Recursive CTEs | Not supported | Fully supported | | `FOR XML` | Not supported | Fully supported | | Transaction isolation levels | Snapshot only | All levels | | `CREATE USER` | Not supported | Fully supported | | Temporal tables | Not supported | Fully supported | | Full-text search | Not supported | Fully supported | ## Fabric-Specific Context - **Authentication**: Entra ID only — SQL auth is not supported in Fabric - **Token audience**: `https://database.windows.net/.default` (same as Warehouse) - **OneLake replication**: Tables automatically replicate to OneLake as Delta/Parquet - **SQL projects**: Uses standard `.sqlproj` format for schema-as-code - **Do NOT apply Warehouse T-SQL restrictions** to Fabric SQL Database code ## Reference - Microsoft Learn: [SQL database in Fabric (overview)](https://learn.microsoft.com/fabric/database/sql/overview) - Microsoft Learn: [Features comparison