DB2SchemaManager

Constructor. Accepts the Connection instance to manage the schema for

Return associated platform.

Try any method on the schema manager. Normally a method throws an exception when your DBMS doesn't support it or if an error occurs.

This method allows you to try and method on your SchemaManager instance and will return false if it does not work or is not supported.

$result = $sm->tryMethod('dropView', 'view_name');

List the available databases for this connection

List the available sequences for this connection

List the columns for a given table.

In contrast to other libraries and to the old version of Doctrine, this column definition does try to contain the 'primary' field for the reason that it is not portable accross different RDBMS. Use {see listTableIndexes($tableName)} to retrieve the primary key of a table. We're a RDBMS specifies more details these are held in the platformDetails array.

List the indexes for a given table returning an array of Index instances.

Keys of the portable indexes list are all lower-cased.

Return true if all the given tables exist.

Return a list of all tables in the current database

Apparently creator is the schema not the user who created it: {@link http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.sqlref/db2z_sysibmsystablestable.htm}

Filter asset names if they are configured to return only a subset of all the found elements.

List the tables for this connection

List the views this connection has

List the foreign keys for the given table

Drops a database.

NOTE: You can not drop the database this SchemaManager is currently connected to.

Drop the given table

Drop the index from the given table

Drop the constraint from the given table

Drops a foreign key from a table.

Drops a sequence with a given name.

Drop a view

Creates a new database.

Create a new table.

Create a new sequence

Create a constraint on a table

Create a new index on a table

Create a new foreign key

Create a new view

Drop and create a constraint

Drop and create a new index on a table

Drop and create a new foreign key

Drop and create a new sequence

Drop and create a new table.

Drop and creates a new database.

Drop and create a new view

Alter an existing tables schema

Rename a given table to another name

Methods for filtering return values of list*() methods to convert the native DBMS data definition to a portable Doctrine definition

Independent of the database the keys of the column list result are lowercased.

The name of the created column instance however is kept in its case.

Get Table Column Definition

Aggregate and group the index results according to the required data result.

Create a schema instance for the current database.

Create the configuration for this schema.

The search path for namespaces in the currently connected database.

The first entry is usually the default namespace in the Schema. All further namespaces contain tables/sequences which can also be addressed with a short, not full-qualified name.

For databases that don't support subschema/namespaces this method returns the name of the currently connected database.

Given a table comment this method tries to extract a typehint for Doctrine Type, or returns the type given as default.