T-SQL surface area
- In Microsoft Fabric, you can create, change, and delete tables, and add, change, or remove data, but only in the Warehouse part, not in the SQL analytics part of the Lakehouse.
- However, you can still make your own views, functions, and procedures using T-SQL with the tables in the SQL analytics part of the Lakehouse.
T-SQL Limitations in Microsoft Fabric
At this time, the following list of commands is NOT currently supported.
- ALTER TABLE ADD/ALTER/DROP COLUMN
- BULK LOAD
- CREATE ROLE
- CREATE USER
- Hints
- Identity Columns
- Manually created multi-column stats
- MATERIALIZED VIEWS
- MERGE
- OPENROWSET
- PREDICT
- Queries targeting system and user tables
- Recursive queries
- Result Set Caching
- Schema and Table names can’t contain / or \
- SELECT – FOR
- SET ROWCOUNT
- SET TRANSACTION ISOLATION LEVEL
sp_showspaceused- Temp Tables
- Triggers
- TRUNCATE
Data types in Warehouse
Warehouse supports a subset of T-SQL data types:
| Category | Supported data types |
|---|---|
| Exact numerics | bit bigint int smallint decimal numeric |
| Approximate numerics | float real |
| Date and time | date datetime2 time |
| Character strings | char varchar |
| Binary strings | varbinary uniqueidentifer |
Unsupported data types
| Unsupported data type | Alternatives available |
|---|---|
| money and smallmoney | Use decimal, however note that it can’t store the monetary unit. |
| datetime and smalldatetime | Use datetime2. |
| nchar and nvarchar | Use char and varchar respectively, as there’s no similar unicode data type in Parquet. |
| text and ntext | Use varchar. |
| image | Use varbinary. |
