SHOW TABLES

Also read the SQL statement syntax on SHOW TABLES

NameData TypeDescription
ID GUID Internal list GUID. This property never change and can be used to query the list in replacement of list title.
Name String Internal list name.
Title String List title. Is normally used to query the list.
Description String Description of the list and its content.
Created DateTime Indicates when the list was created.
Modified DateTime Indicates when the list was last modified.
LastDeleted DateTime Indicates when an item was last deleted from the list.
ItemCount Int32 Indicates the current number of items in the list.
AllowDeletion Boolean True if items can be deleted from the list.
EnableAttachments Boolean True if the list allows attachments on items.
RequireCheckout Boolean True if items must be checked out before they can be modified.
ReadSecurity Int32 Indicates the Read security setting for the list.
[1]: All users have Read access to all items.
[2]: Users have Read access only to items that they create.
WriteSecurity Int32 Indicates the Write security setting for the list.
[1]: All users have Write access to all items.
[2]: Users have Write access only to items that they create.
[3]: Users cannot modify any items.
Hidden Boolean Indicates if the list is hidden. Hidden lists do not appear on the lists page or as option for lookup fields in SharePoint.
ShowUser Boolean Indicates if names of users are shown in the list.
Author Int32 The ID of the user who created the list.
DefaultViewUrl String The relative URL of the default view for the list.
MobileDefaultViewUrl String The relative URL of the mobile default view for the list.
ImageUrl String The relative URL of the icon that represents the list.
BaseType Int32 Indicates the base type of the list.
[0]: Generic list
[1]: Document library
[2]: Reserved, not used
[3]: Discussion board
[4]: Survey list
[5]: Issue tracking list
Version Int32 The version number of the list. This version is automatically incremented when the list defintion is changed.
EnableModeration Boolean True if content approval is enabled for the list.
EnableVersioning Boolean True if versioning is enabled to the document library.

Skip Navigation Links.

Visa     MasterCard