SelectTableCollection Class

In This Topic

Represents a collection of tables and subqueries in a SelectStatement object.

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class SelectTableCollection 
   Inherits System.Collections.CollectionBase
   Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

public sealed class SelectTableCollection : System.Collections.CollectionBase, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

Remarks

Use SelectTableCollection class to manage tables used in a query. To access the collection use the SelectStatement.Tables property.

Example

In the following sample we retrieve a collection of SelectTables from an DB2SelectStatement object 'statement' and print them. For example, if statement represents the command

SELECT * FROM test.dept tDept,test.emp tEmp

the output of the sample would be the following:

test.dept tDept
test.emp tEmp

csharp

SelectTableCollection collection = statement.Tables;
foreach (SelectTable table in collection)
        Console.WriteLine(table.ToString());

Visual Basic

Dim collection As SelectTableCollection = statement.Tables
For Each table In collection
        Console.WriteLine(table.ToString())
Next

Inheritance Hierarchy

System.Object
System.Collections.CollectionBase
Devart.Common.SelectTableCollection

Reference

SelectTableCollection Members
Devart.Common Namespace

Send Feedback