SHOW TABLES

SHOW TABLES displays information about all visible lists in the site. The result table provides valuable information that can be useful in many programming scenarios, such as when a list was created, last modified or how many items a list currently contains. The SHOW LISTS command is a synonym for SHOW TABLES.

This command always return same columns. For the complete listing see the SHOW TABLE reference.

Syntax

SHOW {TABLES | LISTS};

Code example: Get all lists and libraries in a site and print name and type. Generic lists have type 0 and document libraries have type 1.

using (var connection = new SharePointConnection(connectionString))
{
    connection.Open();
    using (var command = new SharePointCommand("SHOW TABLES", connection))
    {
        using (var reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                Console.WriteLine(reader["Title"].ToString().PadRight(40) + " : " + reader["BaseType"].ToString());
            }
        }
    }
}

Code result

Announcements                            : 0
Calendar                                 : 0
Content type publishing error log        : 0
Converted Forms                          : 1
Customized Reports                       : 1
Form Templates                           : 1
Links                                    : 0
List Template Gallery                    : 1
Master Page Gallery                      : 1
Reporting Metadata                       : 0
Reporting Templates                      : 1
Shared Documents                         : 1
Site Assets                              : 1
Site Pages                               : 1
Solution Gallery                         : 1
Style Library                            : 1
Tasks                                    : 0
TaxonomyHiddenList                       : 0
Team Discussion                          : 0
Theme Gallery                            : 1
User Information List                    : 0
Web Part Gallery                         : 1
wfpub                                    : 1