Todd Chittenden on 18 Feb 2025 22:12:54
In Lakehouses and Warehouses, I can use SSMS and script out an existing table with simple SSMS right-click context menu. But for the CREATE TABLE statement that gets generated, it includes the clause "ON [PRIMARY]" and this is NOT allowed here.
SSMS needs better awareness of the types of databases it is connecting to. If you do this connected to a Synapse data warehouse, you don't get this clause.