Forum Discussion
SSMS - Fabric WAREHOUSE SQL endpoint - NOT grouped by OBJECT TYPE instead by Schema.
Hi AJAJ ,
Thanks for the patience. In SSMS 22.4.1 and newer, Object Explorer supports grouping objects by type (classic view: Tables, Views, Stored Procedures) or by schema. You can configure grouping behavior in SSMS settings under Tools - Options - SQL Server Object Explorer - General - Group objects by Schema.
If the Object Explorer view in SSMS doesn’t display objects exactly as you prefer, you can use system catalog views to list objects with type and schema information. For example, you can query sys.objects or INFORMATION_SCHEMA.TABLES / INFORMATION_SCHEMA.VIEWS to see all database objects along with their types and schemas. Additionally, the Fabric portal Data Explorer provides a graphical interface to browse warehouse objects and schemas.
For feature requests or enhancements, you can submit feedback via the Fabric Feedback portal.
Refer These Docs
https://learn.microsoft.com/en-us/ssms/object/open-and-configure-object-explorer
https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity
https://learn.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-objects-transac…https://learn.microsoft.com/en-us/sql/relational-databases/system-information-schema-views/tables-t…
deborshi_nag Thanks. I guess once you upgrade SSMS to 20+ you might see objects getting group by schema for fabric warehouses / lakehoues like the left side of the screenshot.
I will see if anyone else is able to get SSMS to go by object name instead of schema name. Thanks for your time. As of now issue is still unresolved.
Can you share a screenshot of how Object Explorer appears when you untick the "Group objects by schema" option? Please restart the application when you have changed the setting.
deborshi_nag using the latest SSMS 22 available as of 03/25/2026
When i connect to "SQL Server" i see table
dbo.table1schema1.table2
but when connected to fabric warehouse it still shows grouped by schema. as showed in screenshot top left most of this thread and its frustrating.doesnt matter if the below is unchecked.