|
Class TMssqlMetaData
TMssqlMetaData loads MSSQL database table and column information.
-
TComponent
-
TDbMetaData
-
TMssqlMetaData
Methods summary
protected
string
|
#
getTableInfoClass( )
Returns
string TDbTableInfo class name.
Overrides
|
public
string
|
#
quoteTableName( string $name )
Quotes a table name for use in a query.
Quotes a table name for use in a query.
Parameters
- $name
string $name table name
Returns
string the properly quoted table name
Overrides
|
public
string
|
#
quoteColumnName( string $name )
Quotes a column name for use in a query.
Quotes a column name for use in a query.
Parameters
- $name
string $name column name
Returns
string the properly quoted column name
Overrides
|
public
string
|
#
quoteColumnAlias( string $name )
Quotes a column alias for use in a query.
Quotes a column alias for use in a query.
Parameters
- $name
string $name column alias
Returns
string the properly quoted column alias
Overrides
|
protected
TMssqlTableInfo
|
#
createTableInfo( string $table )
Get the column definitions for given table.
Get the column definitions for given table.
Parameters
Returns
|
protected
array
|
#
getCatalogSchemaTableName( string $table )
Parameters
Returns
array tuple($catalogName,$schemaName,$tableName)
|
protected
|
|
protected
TMssqlTableInfo
|
#
createNewTableInfo( string $col )
Parameters
- $col
string table schema name
Returns
|
protected
array
|
#
getConstraintKeys( string $col )
Gets the primary and foreign key column details for the given table.
Gets the primary and foreign key column details for the given table.
Parameters
Returns
array tuple ($primary, $foreign)
|
protected
array
|
#
getForeignConstraints( string $col )
Gets foreign relationship constraint keys and table name
Gets foreign relationship constraint keys and table name
Parameters
Returns
array foreign relationship table name and keys.
|
protected
boolean
|
#
isForeignKeyColumn( string $columnId, TPgsqlTableInfo $tableInfo )
Parameters
Returns
boolean true if column is a foreign key.
|
public
array
|
#
findTableNames( string $schema = 'dbo' )
Returns all table names in the database.
Returns all table names in the database.
Parameters
- $schema
string $schema the schema of the tables. Defaults to empty string, meaning the current
or default schema. If not empty, the returned table names will be prefixed with
the schema name.
Returns
array all table names in the database.
|
Methods inherited from TComponent
__call(),
__destruct(),
__get(),
__isset(),
__set(),
__sleep(),
__unset(),
__wakeup(),
addParsedObject(),
asa(),
attachBehavior(),
attachBehaviors(),
attachClassBehavior(),
attachEventHandler(),
canGetProperty(),
canSetProperty(),
clearBehaviors(),
createdOnTemplate(),
detachBehavior(),
detachBehaviors(),
detachClassBehavior(),
detachEventHandler(),
disableBehavior(),
disableBehaviors(),
enableBehavior(),
enableBehaviors(),
evaluateExpression(),
evaluateStatements(),
fxAttachClassBehavior(),
fxDetachClassBehavior(),
getAutoGlobalListen(),
getBehaviorsEnabled(),
getClassHierarchy(),
getEventHandlers(),
getListeningToGlobalEvents(),
getSubProperty(),
hasEvent(),
hasEventHandler(),
hasProperty(),
isa(),
listen(),
raiseEvent(),
setSubProperty(),
unlisten()
|
|