Class \Prado\Data\Common\Mssql\TMssqlMetaData

TMssqlMetaData loads MSSQL database table and column information.

Class hierarchy

\Prado\Data\Common\Mssql\TMssqlMetaData

Extended by

\Prado\Data\Common\TDbMetaData

Extended by

\Prado\TComponent

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

Methods summary
`public`	`findTableNames([string $schema = 'dbo' ]) : array<string\|int, mixed>` Returns all table names in the database.
`public`	`quoteColumnAlias(string $name) : string` Quotes a column alias for use in a query.
`public`	`quoteColumnName(string $name) : string` Quotes a column name for use in a query.
`public`	`quoteTableName(string $name) : string` Quotes a table name for use in a query.
`protected`	`createNewTableInfo(array<string\|int, mixed> $col) : TMssqlTableInfo`
`protected`	`createTableInfo(string $table) : TMssqlTableInfo` Get the column definitions for given table.
`protected`	`getCatalogSchemaTableName(string $table) : array<string\|int, mixed>`
`protected`	`getConstraintKeys(array<string\|int, mixed> $col) : array<string\|int, mixed>` Gets the primary and foreign key column details for the given table.
`protected`	`getForeignConstraints(array<string\|int, mixed> $col) : array<string\|int, mixed>` Gets foreign relationship constraint keys and table name
`protected`	`getTableInfoClass() : string`
`protected`	`isForeignKeyColumn(string $columnId, TMssqlTableInfo $tableInfo) : bool`
`protected`	`processColumn(TMssqlTableInfo $tableInfo, array<string\|int, mixed> $col) : mixed`

Inherited methods
__call, __callStatic, __clone, __construct, __destruct, __get, __isset, __set, __sleep, __unset, __wakeup, addParsedObject, asa, attachBehavior, attachBehaviors, attachClassBehavior, attachEventHandler, callBehaviorsMethod, canGetProperty, canSetProperty, clearBehaviors, createCommandBuilder, createdOnTemplate, detachBehavior, detachBehaviors, detachClassBehavior, detachEventHandler, disableBehavior, disableBehaviors, enableBehavior, enableBehaviors, evaluateExpression, evaluateStatements, findTableNames, fxAttachClassBehavior, fxDetachClassBehavior, getAutoGlobalListen, getBehaviors, getBehaviorsEnabled, getClassHierarchy, getDbConnection, getEventHandlers, getInstance, getListeningToGlobalEvents, getSubProperty, getTableInfo, hasEvent, hasEventHandler, hasMethod, hasProperty, isa, listen, quoteColumnAlias, quoteColumnName, quoteTableName, raiseEvent, setSubProperty, unlisten, _getZappableSleepProps, createTableInfo, getCallChain, getClassFxEvents, getTableInfoClass, instanceBehavior, filter_prado_fx

Constants summary
`public mixed`	`DEFAULT_SCHEMA`	`'dbo'`

Inherited constants
`\Prado\TComponent::GLOBAL_RAISE_EVENT_LISTENER`