xdev.db.sql

Class Table

java.lang.Object

xdev.db.sql.SqlObject

xdev.db.sql.Table

All Implemented Interfaces:

Serializable

Direct Known Subclasses:

VirtualTable

public class Table
extends SqlObject

This class represents a table in the SQL API.

It can be constructed with a name only, or optionally with a schema and an alias.

It is also possible to create a Column object, using the alias of this table with column(String).

Author:

XDEV Software

See Also:

VirtualTable, Serialized Form

Constructor Summary

Constructors

Constructor and Description
Table(String name) Creates a new table object with a name only.
Table(String name, String alias) Creates a table object with a name and an alias, but without a schema.
Table(String schema, String name, String alias) Create a table object with a schema, name and an alias.

Method Summary

Modifier and Type	Method and Description
protected void	_updateDelegate(String name)
protected void	_updateDelegate(String name, String alias)
protected void	_updateDelegate(String schema, String name, String alias)
Table	AS(String alias) Returns a new table object with a new alias.
Column	column(String name) Creates a column object with this table as prefix.
String	getAlias() Returns the alias of this table object, may be null.
String	getSchema() Returns the schema of this table object, may be null.
String	getTableName() Returns the name of this table object.

Methods inherited from class xdev.db.sql.SqlObject

toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

Table

public Table(String name)

Creates a new table object with a name only.

Parameters:

name - the name of the table

Table

public Table(String name,
             String alias)

Creates a table object with a name and an alias, but without a schema.

Parameters:

name - the name of the table

alias - the alias of the table

Table

public Table(String schema,
             String name,
             String alias)

Create a table object with a schema, name and an alias.

Parameters:

schema - the schema of the table

name - the name of the table

alias - the alias of the table

Method Detail

_updateDelegate

protected void _updateDelegate(String name)

_updateDelegate

protected void _updateDelegate(String name,
                               String alias)

_updateDelegate

protected void _updateDelegate(String schema,
                               String name,
                               String alias)

AS

public Table AS(String alias)

Returns a new table object with a new alias.

The name and schema are taken from this table object.

Parameters:

alias - the new alias.

Returns:

a new table object

getSchema

public String getSchema()

Returns the schema of this table object, may be null.

Returns:

the schema of this table object

getTableName

public String getTableName()

Returns the name of this table object.

Returns:

the name of this table object

getAlias

public String getAlias()

Returns the alias of this table object, may be null.

Returns:

the alias of this table object

column

public Column column(String name)

Creates a column object with this table as prefix.

Useful if a query uses a table with more aliases.

Parameters:

name - the name of the column

Returns:

a new column object

Since:

3.2