Controls how SharePoint lists and views are discovered and exposed as tables.

Data Type

string

Default Value

"ListsOnly"

Remarks

The ExposedTableTypes property determines which SharePoint schema objects appear as tables when querying metadata.

• ListsOnly (default) — Only lists are exposed. All existing column-visibility properties (ShowHiddenColumns, ShowPredefinedColumns) are respected.
• DefaultViewsOnly — Only the default view of each list is exposed. Columns are filtered to the fields defined in the default view, plus the ID primary key. ShowHiddenColumns and ShowPredefinedColumns are ignored.
• ListsAndDefaultViews — Both lists and their default views are exposed. Lists respect all column-visibility properties; views filter columns to their field set.
• ListsAndAllViews — Both lists and all of their views are exposed. Lists respect all column-visibility properties; views filter columns to their field set.

In all modes, the TableListTypes property is respected to filter eligible list templates. Views with no fields are not exposed. The ID column is always included in view-based tables.