foreign()

foreign(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for creating a foreign key.

Parameters

Returns

drop()

drop(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop table command.

Parameters

Returns

wrap()

wrap(string  $value) : string

Wrap a value in keyword identifiers.

Parameters

Returns

__construct()

__construct(\Laravel\Database\Connection  $connection) : void

Create a new database grammar instance.

Parameters

wrap_table()

wrap_table(string  $table) : string

Wrap a table in keyword identifiers.

Parameters

Returns

parameterize()

parameterize(array  $values) : string

Create query parameters from an array of values.

Returns "?, ?, ?", which may be used as PDO place-holders $parameters = $grammar->parameterize(array(1, 2, 3));

// Returns "?, "Taylor"" since an expression is used
$parameters = $grammar->parameterize(array(1, DB::raw('Taylor')));

Parameters

Returns

parameter()

parameter(mixed  $value) : string

Get the appropriate query parameter string for a value.

// Returns a "?" PDO place-holder $value = $grammar->parameter('Taylor Otwell');

// Returns "Taylor Otwell" as the raw value of the expression
$value = $grammar->parameter(DB::raw('Taylor Otwell'));

Parameters

Returns

columnize()

columnize(array  $columns) : string

Create a comma-delimited list of wrapped column names.

// Returns ""Taylor", "Otwell"" when the identifier is quotes $columns = $grammar->columnize(array('Taylor', 'Otwell'));

Parameters

Returns

create()

create(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : array

Generate the SQL statements for a table creation command.

Parameters

Returns

add()

add(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : array

Generate the SQL statements for a table modification command.

Parameters

Returns

primary()

primary(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for creating a primary key.

Parameters

Returns

unique()

unique(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for creating a unique index.

Parameters

Returns

fulltext()

fulltext(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for creating a full-text index.

Parameters

Returns

index()

index(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for creating a regular index.

Parameters

Returns

rename()

rename(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a rename table command.

Parameters

Returns

drop_column()

drop_column(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop column command.

Parameters

Returns

drop_primary()

drop_primary(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop primary key command.

Parameters

Returns

drop_unique()

drop_unique(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop unique key command.

Parameters

Returns

drop_fulltext()

drop_fulltext(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop full-text key command.

Parameters

Returns

drop_index()

drop_index(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop unique key command.

Parameters

Returns

drop_foreign()

drop_foreign(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Drop a foreign key constraint from the table.

Parameters

Returns

drop_constraint()

drop_constraint(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Drop a constraint from the table.

Parameters

Returns

type()

type(\Laravel\Fluent  $column) : string

Get the appropriate data type definition for the column.

Parameters

Returns

default_value()

default_value(mixed  $value) : string

Format a value so that it can be used in SQL DEFAULT clauses.

Parameters

Returns

wrap_value()

wrap_value(string  $value) : string

Wrap a single string value in keyword identifiers.

Parameters

Returns

columns()

columns(\Laravel\Database\Schema\Table  $table) : array

Create the individual column definitions for the table.

Parameters

Returns

unsigned()

unsigned(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $column) : string

Get the SQL syntax for indicating if a column is unsigned.

Parameters

Returns

nullable()

nullable(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $column) : string

Get the SQL syntax for indicating if a column is nullable.

Parameters

Returns

defaults()

defaults(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $column) : string

Get the SQL syntax for specifying a default value on a column.

Parameters

Returns

incrementer()

incrementer(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $column) : string

Get the SQL syntax for defining an auto-incrementing column.

Parameters

Returns

key()

key(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command, string  $type) : string

Generate the SQL statement for creating a new index.

Parameters

Returns

drop_key()

drop_key(\Laravel\Database\Schema\Table  $table, \Laravel\Fluent  $command) : string

Generate the SQL statement for a drop key command.

Parameters

Returns

type_string()

type_string(\Laravel\Fluent  $column) : string

Generate the data-type definition for a string.

Parameters

Returns

type_integer()

type_integer(\Laravel\Fluent  $column) : string

Generate the data-type definition for an integer.

Parameters

Returns

type_float()

type_float(\Laravel\Fluent  $column) : string

Generate the data-type definition for an integer.

Parameters

Returns

type_decimal()

type_decimal(\Laravel\Fluent  $column) : string

Generate the data-type definition for a decimal.

Parameters

Returns

type_boolean()

type_boolean(\Laravel\Fluent  $column) : string

Generate the data-type definition for a boolean.

Parameters

Returns

type_date()

type_date(\Laravel\Fluent  $column) : string

Generate the data-type definition for a date.

Parameters

Returns

type_timestamp()

type_timestamp(\Laravel\Fluent  $column) : string

Generate the data-type definition for a timestamp.

Parameters

Returns

type_text()

type_text(\Laravel\Fluent  $column) : string

Generate the data-type definition for a text column.

Parameters

Returns

type_blob()

type_blob(\Laravel\Fluent  $column) : string

Generate the data-type definition for a blob.

Parameters

Returns