New Fabric SQL Datasbase does not let me CREATE TABLE from SSMS

With Fabric SQL Databases being so new, there WILL be learning curves (and bumps in the road) as we, the community struggle to adopt them and learn of the nuance differences. One key difference is the Connection Strings.

I have been using the Connection String from a Fabric Warehouse or Lakehouse in SSMS for quite some time (I usually set up Registered Servers for them.) And that Connection String exposes all of the database type objects under one server. You can even run cross-database queries if you want to move data from a Lakehouse to a Warehouse. And the new Fabric SQL Database is also there. But it is NOT there as a typical SQL Database because the SQL Endpoint is an ANALYTIC Endpoint. 

If you open the SQL Database in the browser, then click "Open in"  >> "SQL Server Management Studio":

You get a dialog that shows the SQL Endpoint and a Database name (which is your database plus a GUID after it).

Compare this connection string to the one from the Lakehouse endpoint. They will be different:

(same 'server' GUID, but different suffixes)

Behind the DATABASE Endpoint you have full SQL Database capabilities: PRIMARY KEYS, INDEXES, etc.

Behind the ANALYTIC/DATA WAREHOUSE Endpoint you have ANALYTIC capabilities. 

One allows CREATE TABLE and one does not. But same data.

Microsoft is still working on things like removing the GUID from the SQL Endpoint Database name, and other minor bugs.

This was an invaluable revelation for me pointed out by someone in the forums.