Public Member Functions | Public Attributes

ADODB2_mssql Class Reference

Inheritance diagram for ADODB2_mssql:
Inheritance graph
[legend]
Collaboration diagram for ADODB2_mssql:
Collaboration graph
[legend]

List of all members.

Public Member Functions

 MetaType ($t, $len=-1, $fieldobj=false)
 ActualType ($meta)
 AddColumnSQL ($tabname, $flds)
 DropColumnSQL ($tabname, $flds)
 _CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
 _IndexSQL ($idxname, $tabname, $flds, $idxoptions)
 _GetSize ($ftype, $ty, $fsize, $fprec)

Public Attributes

 $databaseType = 'mssql'
 $dropIndex = 'DROP INDEX %2$s.%1$s'
 $renameTable = "EXEC sp_rename '%s','%s'"
 $renameColumn = "EXEC sp_rename '%s.%s','%s'"
 $typeX = 'TEXT'
 $typeXL = 'TEXT'

Detailed Description

Definition at line 44 of file datadict-mssql.inc.php.


Member Function Documentation

ADODB2_mssql::_CreateSuffix ( fname,
&$  ftype,
fnotnull,
fdefault,
fautoinc,
fconstraint,
funsigned 
)

Reimplemented from ADODB_DataDict.

Definition at line 156 of file datadict-mssql.inc.php.

ADODB2_mssql::_GetSize ( ftype,
ty,
fsize,
fprec 
)

GENERATE THE SIZE PART OF THE DATATYPE $ftype is the actual type $ty is the type defined originally in the DDL

Reimplemented from ADODB_DataDict.

Definition at line 270 of file datadict-mssql.inc.php.

ADODB2_mssql::_IndexSQL ( idxname,
tabname,
flds,
idxoptions 
)

Reimplemented from ADODB_DataDict.

Definition at line 239 of file datadict-mssql.inc.php.

References $sql.

ADODB2_mssql::ActualType ( meta  ) 

Returns the actual type given a character code.

C: varchar X: CLOB (character large object) or largest varchar size if CLOB is not supported C2: Multibyte varchar X2: Multibyte CLOB

B: BLOB (binary large object)

D: Date T: Date-time L: Integer field suitable for storing booleans (0 or 1) I: Integer F: Floating point number N: Numeric or decimal number

Reimplemented from ADODB_DataDict.

Definition at line 79 of file datadict-mssql.inc.php.

ADODB2_mssql::AddColumnSQL ( tabname,
flds 
)

Reimplemented from ADODB_DataDict.

Definition at line 112 of file datadict-mssql.inc.php.

References $sql, ADODB_DataDict::_GenFields(), and ADODB_DataDict::TableName().

Here is the call graph for this function:

ADODB2_mssql::DropColumnSQL ( tabname,
flds 
)

Definition at line 140 of file datadict-mssql.inc.php.

References $sql, and ADODB_DataDict::TableName().

Here is the call graph for this function:

ADODB2_mssql::MetaType ( t,
len = -1,
fieldobj = false 
)

Reimplemented from ADODB_DataDict.

Definition at line 55 of file datadict-mssql.inc.php.


Member Data Documentation

ADODB2_mssql::$databaseType = 'mssql'

Definition at line 45 of file datadict-mssql.inc.php.

ADODB2_mssql::$dropIndex = 'DROP INDEX %2$s.%1$s'

Reimplemented from ADODB_DataDict.

Definition at line 46 of file datadict-mssql.inc.php.

ADODB2_mssql::$renameColumn = "EXEC sp_rename '%s.%s','%s'"

Reimplemented from ADODB_DataDict.

Definition at line 48 of file datadict-mssql.inc.php.

ADODB2_mssql::$renameTable = "EXEC sp_rename '%s','%s'"

Reimplemented from ADODB_DataDict.

Definition at line 47 of file datadict-mssql.inc.php.

ADODB2_mssql::$typeX = 'TEXT'

Definition at line 50 of file datadict-mssql.inc.php.

ADODB2_mssql::$typeXL = 'TEXT'

Definition at line 51 of file datadict-mssql.inc.php.


The documentation for this class was generated from the following file: