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

SqlSelectStatement statement = new SqlSelectStatement();     

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 SqlSelectStatement()

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

Reference

SelectTable Members
Devart.Common Namespace

Send Feedback