Represents a list of all items in the Table Catalog.
All collections have the “Item(NameOrIndex)” method. This is the default method for all collections and returns an item in the collection at a particular index or with a specific name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements cause identical behavior: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy") |
This example shows how to write all the information about the tables in the Table Catalog to the Console window:
With (ActiveDocument.Sections["Query"].DataModel)
{
var NumTables = Catalog.CatalogItems.Count
for (I = 1; I <= NumTables;I++)
{
OutputString = "Database Name =" + Catalog.CatalogItems[I].DatabaseName
OutputString = OutputString +":Database Owner=" +
Catalog.CatalogItems[I].Owner
OutputString = OutputString +":Table Name=" +
Catalog.CatalogItems[I].Name
Console.Write(OutputString+"\r\n")
}
}