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