## Class TMssqlMetaData

Description

TMssqlMetaData loads MSSQL database table and column information.

- since: 3.1
- version: $Id: TPgsqlMetaData.php 1866 2007-04-14 05:02:29Z wei $
- author: Wei Zhuo <weizho[at]gmail[dot]com>

Located in /Data/Common/Mssql/TMssqlMetaData.php (line 27)

    TComponent
       |
       --TDbMetaData
          |
          --TMssqlMetaData

Method Summary
TMssqlTableInfo createNewTableInfo (string $col, string 1)
TMssqlTableInfo createTableInfo (string $table)
array getCatalogSchemaTableName (string $table)
array getConstraintKeys (string $col, string 1)
array getForeignConstraints (string $col, string 1)
string getTableInfoClass ()
boolean isForeignKeyColumn (string $columnId, TPgsqlTableInfo $tableInfo)
void processColumn (TMssqlTableInfo $tableInfo, array $col)
Methods
createNewTableInfo (line 132)

- access: protected

TMssqlTableInfo createNewTableInfo (string $col, string 1)

- string 1: table name.
- string $col: table schema name

createTableInfo (line 42)

Get the column definitions for given table.

- return: table information.
- access: protected

TMssqlTableInfo createTableInfo (string $table)

- string $table: table name.

Redefinition of:

TDbMetaData::createTableInfo()
  This method should be implemented by decendent classes.

getCatalogSchemaTableName (line 82)

- return: tuple($catalogName,$schemaName,$tableName)
- access: protected

array getCatalogSchemaTableName (string $table)

- string $table: table name

getConstraintKeys (line 150)

Gets the primary and foreign key column details for the given table.

- return: tuple ($primary, $foreign)
- access: protected

array getConstraintKeys (string $col, string 1)

- string 1: table name.
- string $col: schema name

getForeignConstraints (line 177)

Gets foreign relationship constraint keys and table name

- return: foreign relationship table name and keys.
- access: protected

array getForeignConstraints (string $col, string 1)

- string 1: table name
- string $col: database name

getTableInfoClass (line 32)

- return: TDbTableInfo class name.
- access: protected

string getTableInfoClass ()

Redefinition of:

TDbMetaData::getTableInfoClass()

isForeignKeyColumn (line 221)

- return: true if column is a foreign key.
- access: protected

boolean isForeignKeyColumn (string $columnId, TPgsqlTableInfo $tableInfo)

- string $columnId: column name.
- TPgsqlTableInfo $tableInfo: table information.

processColumn (line 98)

- access: protected

void processColumn (TMssqlTableInfo $tableInfo, array $col)

- TMssqlTableInfo $tableInfo: table information.
- array $col: column information.

#### Inherited Methods

Inherited From TDbMetaData

> TDbMetaData::__construct()
> TDbMetaData::createCommandBuilder()
> TDbMetaData::createTableInfo()
> TDbMetaData::getDbConnection()
> TDbMetaData::getInstance()
> TDbMetaData::getTableInfo()
> TDbMetaData::getTableInfoClass()

Inherited From TComponent

> TComponent::addParsedObject()
> TComponent::attachEventHandler()
> TComponent::canGetProperty()
> TComponent::canSetProperty()
> TComponent::createdOnTemplate()
> TComponent::detachEventHandler()
> TComponent::evaluateExpression()
> TComponent::evaluateStatements()
> TComponent::getEventHandlers()
> TComponent::getSubProperty()
> TComponent::hasEvent()
> TComponent::hasEventHandler()
> TComponent::hasProperty()
> TComponent::raiseEvent()
> TComponent::setSubProperty()
> TComponent::__get()
> TComponent::__set()

Documentation generated on Mon, 22 Feb 2010 12:18:13 +0000 by phpDocumentor 1.3.0RC4