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

Class: MDB2_Driver_Reverse_odbc

Source Location: /MDB2_Driver_odbc-0.2.0/MDB2/Driver/Reverse/odbc.php

Class Overview

MDB2_Driver_Reverse_Common
   |
   --MDB2_Driver_Reverse_odbc

MDB2 MSSQL driver for the schema reverse engineering module


Author(s):

Methods


Inherited Variables

Inherited Methods


Class Details

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


[ Top ]


Method Detail

getTableConstraintDefinition   [line 250]

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 26]

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 166]

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 385]

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 461]

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 620]

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 543]

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 Mon, 11 Mar 2019 15:51:22 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.