Specifies whether to include system schemas such as guest, sys, INFORMATION_SCHEMA, and schemas prefixed with db_ during schema discovery.

Data Type

bool

Default Value

true

Remarks

When enabled, this property instructs the server to query and expose system-defined schemas alongside user-defined schemas. System schemas typically contain metadata, built-in views, and internal database objects.

These schemas include:

• sys: Contains internal views and catalog information.
• INFORMATION_SCHEMA: Provides standard views for metadata queries.
• guest: Represents access for unauthenticated users.
• Schemas with names starting with db_. For example: db_owner and db_datareader.

Disabling this property can simplify the schema view by omitting internal structures that are not relevant for most data access scenarios.

This property is useful for controlling the visibility of internal SQL Server objects in environments where users only need to work with application data. Set this property to false to streamline metadata discovery or restrict what appears in tools like data explorers or schema browsers.