SelectTable Class

In This Topic

Represents a table or a subquery in the FROM clause of a SELECT statement.

Syntax

Visual Basic
C#

'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

csharp

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);

Visual Basic

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

Reference

SelectTable Members
Devart.Common Namespace

Send Feedback