Forum Discussion
Helper IVSSMS - 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…
Helper IVPraveenVeli Thanks for pointing it out. Never knew there is a button like that.
Anyway - is this a bug on SSMS 2022.4.1?
Advocate II don't know if it's expected behavior in SSMS or a bug. In VS Code I can group objects by type or by schema for Fabric Warehouses, but for SSMS Microsoft documentation on Fabric Warehouse display says objects are grouped by schema by default. I can't find a way to change that in SSMS for Fabric Warehouses right now. I'll keep researching, but if you need to view them by object type, VS Code is the better option I know of.