Excel Add-In for Azure Synapse

Build 26.0.9655

IncludeSystemSchemas

Specifies whether the provider returns objects that reside in system schemas including guest, sys, INFORMATION_SCHEMA, and any schema whose name begins with db_.

Data Type

bool

Default Value

true

Remarks

When this property is set to true, system-schema tables and views appear in metadata queries and can be selected or queried just like user tables.

When this property is set to false, the add-in filters those objects out of metadata results. Applications that enumerate schemas or tables see only user-defined objects.

This property is helpful when you want to declutter design-time metadata lists. For example, in business intelligence tools that pull every schema or when you need to expose system objects for advanced diagnostics.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655