cakephp / phinx

	/**

	 * {@inheritdoc}

	 */

	public function hasTable( $tableName ) {

		$options = $this->getOptions();

		$exists = $this->fetchRow( sprintf(

			"SELECT TABLE_NAME

            FROM INFORMATION_SCHEMA.TABLES

            WHERE TABLE_SCHEMA = '%s' AND TABLE_NAME = '%s'",

			$options['name'],

			$tableName

		) );

		return ! empty( $exists );

	}

	/**

	 * {@inheritdoc}

	 */

	 *

	 * @return array

	 */

	public function describeTable( $tableName ) {

		$options = $this->getOptions();

		// mysql specific

		$sql = sprintf(

			"SELECT *

             FROM information_schema.tables

             WHERE table_schema = '%s'

             AND table_name = '%s'",

			$options['name'],

			$tableName

		);

		return $this->fetchRow( $sql );

	}

	/**

	 * Returns MySQL column types (inherited and MySQL specified).

	 * @return array