Class TMssqlMetaData
TMssqlMetaData loads MSSQL database table and column information.
Method Summary |
protected
TMssqlTableInfo
|
|
protected
TMssqlTableInfo
|
Get the column definitions for given table.
|
protected
array
|
|
protected
array
|
Gets the primary and foreign key column details for the given table.
|
protected
array
|
Gets foreign relationship constraint keys and table name
|
protected
string
|
|
protected
boolean
|
|
protected
void
|
|
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
Input |
string | $col | table schema name |
string | 1 | table name. |
Output |
Exception |
|
createTableInfo
Get the column definitions for given table.
Input |
string | $table | table name. |
Output |
TMssqlTableInfo
| table information. |
Exception |
|
getCatalogSchemaTableName
protected array getCatalogSchemaTableName |
(string $table ) |
Input |
string | $table | table 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 | $col | schema name |
string | 1 | table 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 | $col | database name |
string | 1 | table 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 | $columnId | column name. |
TPgsqlTableInfo | $tableInfo | table information. |
Output |
boolean
| true if column is a foreign key. |
Exception |
|
processColumn
Input |
TMssqlTableInfo | $tableInfo | table information. |
array | $col | column information. |
Output |
Exception |
|
|