Class CI_DB_mssql_utility - echiong/testRepo GitHub Wiki

##Class CI_DB_mssql_utility

MS SQL Utility Class

Category: Database
Author: ExpressionEngine Dev Team
Link: http://codeigniter.com/user_guide/database/
Located at system/database/drivers/mssql/mssql_utility.php

##Methods summary

public boolean _list_databases ( )

List databases

Returns boolean

public object _optimize_table ( string $table )

Optimize table query

Generates a platform-specific query so that a table can be optimized

Parameters

$table string
the table name

Returns object

public object _repair_table ( string $table )

Repair table query

Generates a platform-specific query so that a table can be repaired

Parameters

$table string
the table name

Returns object

public mixed _backup ( array $params = array() )

MSSQL Export

Parameters

$params array
Preferences

Returns mixed

Methods inherited from CI_DB_utility

__construct()

backup()

csv_from_result()

database_exists()

list_databases()

optimize_database()

optimize_table()

repair_table()

xml_from_result()

Methods inherited from CI_DB_forge

_reset()

add_column()

add_field()

add_key()

create_database()

create_table()

drop_column()

drop_database()

drop_table()

modify_column()

rename_table()

<table class="summary inherited">
<caption>Properties inherited from <a href="Class CI_DB_utility.md#properties">CI_DB_utility</a></caption>
<tr>
	<td><code>
		<a href="Class CI_DB_utility.md#$data_cache"><var>$data_cache</var></a>, 
		<a href="Class CI_DB_utility.md#$db"><var>$db</var></a>
	</code></td>
</tr>
</table>
<table class="summary inherited">
<caption>Properties inherited from <a href="Class CI_DB_forge.md#properties">CI_DB_forge</a></caption>
<tr>
	<td><code>
		<a href="Class CI_DB_forge.md#$db_char_set"><var>$db_char_set</var></a>, 
		<a href="Class CI_DB_forge.md#$fields"><var>$fields</var></a>, 
		<a href="Class CI_DB_forge.md#$keys"><var>$keys</var></a>, 
		<a href="Class CI_DB_forge.md#$primary_keys"><var>$primary_keys</var></a>
	</code></td>
</tr>
</table>