dotConnect for DB2 Documentation
Devart.Common Namespace / SelectTable Class
Members Example

In This Topic
    SelectTable Class
    In This Topic
    Represents a table or a subquery in the FROM clause of a SELECT statement.
    Syntax
    'Declaration
     
    Public NotInheritable Class SelectTable 
       Inherits SelectStatementNode
    public sealed class SelectTable : SelectStatementNode 
    Example

    This example shows how SelectTables can be used to create a SelectStatement object representing the following query:

    SELECT * FROM test.dept tDept, test.emp tEmp
    
    DB2SelectStatement statement = new DB2SelectStatement();     
    
    statement.Columns.Add("*");
    
    // Create SelectTables, specify their schemas, names and aliases.
    SelectTable dept = new SelectTable("test", "dept", "tDept");
    SelectTable emp = new SelectTable("test", "emp", "tEmp");
    
    statement.Tables.Add(dept);
    statement.Tables.Add(emp);
    Dim statement = New DB2SelectStatement()
    
    statement.Columns.Add("*")
    
    ' Create SelectTables, specify their schemas, names and aliases.
    Dim dept = New SelectTable("test", "dept", "tDept")
    Dim emp = New SelectTable("test", "emp", "tEmp")
    
    statement.Tables.Add(dept)
    statement.Tables.Add(emp)
    Inheritance Hierarchy

    System.Object
       Devart.Common.SelectStatementNode
          Devart.Common.SelectTable

    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also