Create a Table in SQL Analytics EndPoint

Hi JohnAG ,

Thanks for using Fabric Community.

As I understand you would like to create a new schema in Lakehouse.

You can try using below code to transfer the schema, but I believe this is not a recommended approach.

ALTER SCHEMA newschemaname TRANSFER dbo.yourtablename

It seems to have some limitations when we use different schema.

Reference Text:

Lake databases allow creation of custom T-SQL objects, such as schemas, procedures, views, and the inline table-value functions (iTVFs). In order to create custom SQL objects, you MUST create a schema where you will place the objects. Custom SQL objects cannot be placed in dbo schema because it is reserved for the lake tables that are defined in Spark, database designer, or Dataverse.

Link :
https://learn.microsoft.com/en-us/azure/synapse-analytics/metadata/database 

Creation of new schema is recommended in Data Warehouse but not in Lakehouse

Tables in data warehousing - Microsoft Fabric | Microsoft Learn