Overview

Namespaces

  • CzProject
    • SqlGenerator
      • Drivers
      • Statements

Classes

  • AddColumn
  • AddForeignKey
  • AddIndex
  • AlterTable
  • ColumnDefinition
  • CreateTable
  • DropColumn
  • DropForeignKey
  • DropIndex
  • DropTable
  • ForeignKeyDefinition
  • IndexColumnDefinition
  • IndexDefinition
  • Insert
  • ModifyColumn
  • RenameTable
  • Overview
  • Namespace
  • Class

Class AlterTable

CzProject\SqlGenerator\Statements\AlterTable implements CzProject\SqlGenerator\IStatement
Namespace: CzProject\SqlGenerator\Statements
Located at Statements/AlterTable.php
Methods summary
public
# __construct( string $tableName )

Parameters

$tableName
public CzProject\SqlGenerator\Statements\AddColumn
# addColumn( string $name, string $type, array $parameters = NULL, array $options = array() )

Parameters

$name
$type
$parameters
$options
=> value]

Returns

CzProject\SqlGenerator\Statements\AddColumn
public CzProject\SqlGenerator\Statements\DropColumn
# dropColumn( string $column )

Parameters

$column

Returns

CzProject\SqlGenerator\Statements\DropColumn
public CzProject\SqlGenerator\Statements\ModifyColumn
# modifyColumn( string $name, string $type, array $parameters = NULL, array $options = array() )

Parameters

$name
$type
$parameters
$options
=> value]

Returns

CzProject\SqlGenerator\Statements\ModifyColumn
public CzProject\SqlGenerator\Statements\AddIndex
# addIndex( string|null $name, string $type )

Parameters

$name
$type

Returns

CzProject\SqlGenerator\Statements\AddIndex
public CzProject\SqlGenerator\Statements\DropIndex
# dropIndex( string $index )

Parameters

$index

Returns

CzProject\SqlGenerator\Statements\DropIndex
public CzProject\SqlGenerator\Statements\AddForeignKey
# addForeignKey( string $name, string[]|string $columns, string $targetTable, string[]|string $targetColumns = array() )

Parameters

$name
$columns
$targetTable
$targetColumns

Returns

CzProject\SqlGenerator\Statements\AddForeignKey
public CzProject\SqlGenerator\Statements\DropForeignKey
# dropForeignKey( string $foreignKey )

Parameters

$foreignKey

Returns

CzProject\SqlGenerator\Statements\DropForeignKey
public CzProject\SqlGenerator\Statements\AlterTable
# setComment( string|null $comment )

Parameters

$comment

Returns

CzProject\SqlGenerator\Statements\AlterTable
public CzProject\SqlGenerator\Statements\AlterTable
# setOption( string $name, string $value )

Parameters

$name
$value

Returns

CzProject\SqlGenerator\Statements\AlterTable
public string
# toSql( CzProject\SqlGenerator\IDriver $driver )

Returns

string

Implementation of

CzProject\SqlGenerator\IStatement::toSql()
czproject/sql-generator v1.0.1 API documentation API documentation generated by ApiGen