ODBC Driver for Microsoft SharePoint

Build 23.0.8839

Lists

Lists the available lists in SharePoint.

テーブル固有の情報

Lists を使用して、SharePoint のテーブルをリストできます。これは、SharePoint 内の実際のリストだけを返します。本製品 に関連付けられた特別なテーブルは返しません。

WHERE 句で次の列を使用できます:Title およびBaseTemplage。

Columns

Name Type Description
ID [KEY] String The Id of the list.
Title String The title of the list. This column may be used in the WHERE clause and may be used with a wild card (*) character.
Description String A description for the list.
BaseTemplate String Indicates the type of template used to create the list. This column may be used in the WHERE clause.
Version Double The version of the list.
Url String The default URL of the list.
EmailAlias String The email alias of the list.
ImageUrl String The image URL of the list.
ItemCount Integer The number of items in the list.
Item_Deleted Datetime The last time an item was deleted from this list.
Item_Modified Datetime The last time an item was modified from this list.
SendToUrl String The send-to URL of the list.
Created Datetime The time when the list was created.
AllowDeletion String Whether items can be deleted.
AllowMultiResponses Boolean A Boolean indicating if multiple responses are enabled for the survey.
Direction String A string that contains LTR if the reading order is left-to-right, RTL if it is right-to-left, or None.
EnableAssignedToEmail Boolean A Boolean indicating if assigned-to emails are enabled. Only applies to issues lists.
EnableAttachments Boolean A Boolean indicating if attachments may be added to items in the list. Does not apply to document libraries.
EnableModeration Boolean A Boolean indicating if content approval is enabled for the list.
EnableVersioning Boolean A Boolean indicating if versioning is enabled for the list.
Hidden Boolean A Boolean indicating if the list is hidden so that it does not appear on the Documents and Lists page, Quick Launch bar, Modify Site Content page, or Add Column page as an option for lookup fields.
MultipleDataList Boolean A Boolean indicating if a meeting-workspace site contains data for multiple meeting instances within the site.
Ordered Boolean A Boolean indicating if items in the list can be sorted on the Edit View page.
Showuser Boolean A Boolean indicating if the names of users are shown in the results of the survey.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839