Script Table As needs to remove the "ON PRIMARY" clause.

[todd_chittenden]

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.