MDB2
[ class tree: MDB2 ] [ index: MDB2 ] [ all elements ]

Class: MDB2_Driver_Reverse_sqlsrv

Source Location: /MDB2_Driver_sqlsrv-1.5.0b5/MDB2/Driver/Reverse/sqlsrv.php

Class Overview

MDB2_Driver_Reverse_Common
   |
   --MDB2_Driver_Reverse_sqlsrv

MDB2 MSSQL driver for the schema reverse engineering module


Author(s):

Methods


Inherited Variables

Inherited Methods


Class Details

[line 56]
MDB2 MSSQL driver for the schema reverse engineering module


[ Top ]


Method Detail

getTableConstraintDefinition   [line 269]

mixed getTableConstraintDefinition( string $table_name, string $constraint_name)

Get the structure of a constraint into an array
  • Return: data array on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table_name     name of table that should be used in method
string   $constraint_name     name of constraint that should be used in method

[ Top ]

getTableFieldDefinition   [line 68]

mixed getTableFieldDefinition( string $table_name, string $field_name)

Get the structure of a field into an array
  • Return: data array on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table_name     name of table that should be used in method
string   $field_name     name of field that should be used in method

[ Top ]

getTableIndexDefinition   [line 185]

mixed getTableIndexDefinition( string $table_name, string $index_name)

Get the structure of an index into an array
  • Return: data array on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $table_name     name of table that should be used in method
string   $index_name     name of index that should be used in method

[ Top ]

getTriggerDefinition   [line 404]

mixed getTriggerDefinition( string $trigger)

Get the structure of a trigger into an array

EXPERIMENTAL

WARNING: this function is experimental and may change the returned value at any time until labelled as non-experimental

  • Return: data array on success, a MDB2 error on failure
  • Access: public

Parameters:

string   $trigger     name of trigger that should be used in method

[ Top ]

tableInfo   [line 480]

array tableInfo( object|string $result, [int $mode = null])

Returns information about a table or a result set

NOTE: only supports 'table' and 'flags' if $result is a table name.

  • Return: an associative array with the information requested. A MDB2_Error object on failure.
  • See: MDB2_Driver_Common::tableInfo()

Parameters:

object|string   $result     MDB2_result object from a query or a string containing the name of a table. While this also accepts a query result resource identifier, this behavior is deprecated.
int   $mode     a valid tableInfo mode

[ Top ]

_add_flag   [line 642]

void _add_flag( array &$array, string $value)

Adds a string to the flags array if the flag is not yet in there
  • if there is no flag present the array is created


Parameters:

array   &$array     the reference to the flag-array
string   $value     the flag value

[ Top ]

_mssql_field_flags   [line 565]

string _mssql_field_flags( string $table, string $column)

Get a column's flags

Supports "not_null", "primary_key", "auto_increment" (mssql identity), "timestamp" (mssql timestamp), "unique_key" (mssql unique index, unique check or primary_key) and "multiple_key" (multikey index)

mssql timestamp is NOT similar to the mysql timestamp so this is maybe not useful at all - is the behaviour of mysql_field_flags that primary keys are alway unique? is the interpretation of multiple_key correct?


Parameters:

string   $table     the table name
string   $column     the field name

[ Top ]


Documentation generated on Tue, 23 Oct 2012 18:31:20 +0000 by phpDocumentor 1.4.3. PEAR Logo Copyright © PHP Group 2004.