PHP Класс Prado\Data\Common\Mssql\TMssqlMetaData

С версии: 3.1

Наследование: extends Prado\Data\Common\TDbMetaData

Открытые методы

Метод	Описание
findTableNames ( string $schema = 'dbo' ) : array	Returns all table names in the database.
quoteColumnAlias ( string $name ) : string	Quotes a column alias for use in a query.
quoteColumnName ( string $name ) : string	Quotes a column name for use in a query.
quoteTableName ( string $name ) : string	Quotes a table name for use in a query.

Метод	Описание
createNewTableInfo ( $col ) : TMssqlTableInfo
createTableInfo ( $table ) : TMssqlTableInfo	Get the column definitions for given table.
getCatalogSchemaTableName ( $table ) : array
getConstraintKeys ( $col ) : array	Gets the primary and foreign key column details for the given table.
getForeignConstraints ( $col ) : array	Gets foreign relationship constraint keys and table name
getTableInfoClass ( ) : string
isForeignKeyColumn ( $columnId, $tableInfo ) : boolean
processColumn ( $tableInfo, $col )

protected createNewTableInfo ( $col ) : TMssqlTableInfo
Результат	TMssqlTableInfo

Get the column definitions for given table.

protected createTableInfo ( $table ) : TMssqlTableInfo
Результат	TMssqlTableInfo	table information.

Returns all table names in the database.

public findTableNames ( string $schema = 'dbo' ) : array
$schema	string	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.
Результат	array	all table names in the database.

protected getCatalogSchemaTableName ( $table ) : array
Результат	array	tuple($catalogName,$schemaName,$tableName)

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

protected getConstraintKeys ( $col ) : array
Результат	array	tuple ($primary, $foreign)

Gets foreign relationship constraint keys and table name

protected getForeignConstraints ( $col ) : array
Результат	array	foreign relationship table name and keys.

protected getTableInfoClass ( ) : string
Результат	string	TDbTableInfo class name.

protected isForeignKeyColumn ( $columnId, $tableInfo ) : boolean
Результат	boolean	true if column is a foreign key.

protected processColumn ( $tableInfo, $col )

Quotes a column alias for use in a query.

public quoteColumnAlias ( string $name ) : string
$name	string	column alias
Результат	string	the properly quoted column alias

Quotes a column name for use in a query.

public quoteColumnName ( string $name ) : string
$name	string	column name
Результат	string	the properly quoted column name

Quotes a table name for use in a query.

public quoteTableName ( string $name ) : string
$name	string	table name
Результат	string	the properly quoted table name