Packages:
default
System
System.Caching
System.Collections
System.Data
System.Data.ActiveRecord
System.Data.ActiveRecord.Relations
System.Data.ActiveRecord.Scaffold
System.Data.ActiveReecord.Scaffold.InputBuilder
System.Data.Commom.Sqlite
System.Data.Common
System.Data.Common.Mssql
System.Data.Common.Mysql
System.Data.Common.Oracle
System.Data.Common.Pgsql
System.Data.Common.Sqlite
System.Data.DataGateway
System.Data.SqlMap
System.Data.SqlMap.Configuration
System.Data.SqlMap.Statements
System.Exceptions
System.I18N
System.IO
System.Security
System.Util
System.Web
System.Web.Services
System.Web.UI
System.Web.UI.ActiveControls
System.Web.UI.WebControls
System.Web.UI.WebControls.assets
System.Xml


Classes:
Keyword

Class TMssqlMetaData

TComponent
   |
   --TDbMetaData
      |
      --TMssqlMetaData

TMssqlMetaData loads MSSQL database table and column information.

Since: 3.1
Author: Wei Zhuo <weizho[at]gmail[dot]com>

Method Summary
protected  TMssqlTableInfo
createNewTableInfo ( string $col, string 1)
protected  TMssqlTableInfo
createTableInfo ( string $table)
Get the column definitions for given table.
protected  array
getCatalogSchemaTableName ( string $table)
protected  array
getConstraintKeys ( string $col, string 1)
Gets the primary and foreign key column details for the given table.
protected  array
getForeignConstraints ( string $col, string 1)
Gets foreign relationship constraint keys and table name
protected  string
protected  boolean
isForeignKeyColumn ( string $columnId, TPgsqlTableInfo $tableInfo)
protected  void
processColumn ( TMssqlTableInfo $tableInfo, array $col)
Methods Inherited From TDbMetaData
TDbMetaData::createCommandBuilder(), TDbMetaData::getDbConnection(), TDbMetaData::getInstance(), TDbMetaData::getTableInfo(), TDbMetaData::getTableInfoClass()
Methods 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()

Method Details

createNewTableInfo

protected TMssqlTableInfo createNewTableInfo (string $col , string 1 )

Input
string$coltable schema name
string1table name.
Output
Exception

createTableInfo

protected TMssqlTableInfo createTableInfo (string $table )

Get the column definitions for given table.

Input
string$tabletable name.
Output
TMssqlTableInfo table information.
Exception

getCatalogSchemaTableName

protected array getCatalogSchemaTableName (string $table )

Input
string$tabletable name
Output
array tuple($catalogName,$schemaName,$tableName)
Exception

getConstraintKeys

protected array getConstraintKeys (string $col , string 1 )

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

Input
string$colschema name
string1table name.
Output
array tuple ($primary, $foreign)
Exception

getForeignConstraints

protected array getForeignConstraints (string $col , string 1 )

Gets foreign relationship constraint keys and table name

Input
string$coldatabase name
string1table name
Output
array foreign relationship table name and keys.
Exception

getTableInfoClass

protected string getTableInfoClass ()

Output
string TDbTableInfo class name.
Exception

isForeignKeyColumn

protected boolean isForeignKeyColumn (string $columnId , TPgsqlTableInfo $tableInfo )

Input
string$columnIdcolumn name.
TPgsqlTableInfo$tableInfotable information.
Output
boolean true if column is a foreign key.
Exception

processColumn

protected void processColumn (TMssqlTableInfo $tableInfo , array $col )

Input
TMssqlTableInfo$tableInfotable information.
array$colcolumn information.
Output
Exception