字典我要纠错

SqlServerGrammar (Database\Schema\Grammars)

SqlServerGrammar

class SqlServerGrammar extends Grammar (View source)

Methods

array

wrapArray(array $values)

Wrap an array of values.

from Grammar

string

wrapTable(Expression|string $table)

Wrap a table in keyword identifiers.

from Grammar

string

wrap(Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

from Grammar

string

columnize(array $columns)

Convert an array of column names into a delimited string.

from Grammar

string

parameterize(array $values)

Create query parameter place-holders for an array.

from Grammar

string

parameter(mixed $value)

Get the appropriate query parameter place-holder for a value.

from Grammar

string

getValue(Expression $expression)

Get the value of a raw expression.

from Grammar

bool

isExpression(mixed $value)

Determine if the given value is a raw expression.

from Grammar

string

getDateFormat()

Get the format for database stored dates.

from Grammar

string

getTablePrefix()

Get the grammar's table prefix.

from Grammar

$this

setTablePrefix(string $prefix)

Set the grammar's table prefix.

from Grammar

array

compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.

from Grammar

string

compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

from Grammar

array

prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

from Grammar

array

compileChange(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.

from Grammar

bool

supportsSchemaTransactions()

Check if this Grammar supports schema changes wrapped in a transaction.

from Grammar

string

compileTableExists()

Compile the query to determine if a table exists.

string

compileColumnExists(string $table)

Compile the query to determine the list of columns.

string

compileCreate(Blueprint $blueprint, Fluent $command)

Compile a create table command.

string

compileAdd(Blueprint $blueprint, Fluent $command)

Compile a column addition table command.

string

compilePrimary(Blueprint $blueprint, Fluent $command)

Compile a primary key command.

string

compileUnique(Blueprint $blueprint, Fluent $command)

Compile a unique key command.

string

compileIndex(Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

string

compileDrop(Blueprint $blueprint, Fluent $command)

Compile a drop table command.

string

compileDropIfExists(Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

string

compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

string

compileDropPrimary(Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

string

compileDropUnique(Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

string

compileDropIndex(Blueprint $blueprint, Fluent $command)

Compile a drop index command.

string

compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

string

compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.

string

compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.

string

compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.

Details

array wrapArray(array $values)

Wrap an array of values.

Parameters

array

$values

Return Value

array

string wrapTable(Expression|string $table)

Wrap a table in keyword identifiers.

Parameters

Expression|string

$table

Return Value

string

string wrap(Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

Parameters

Expression\|string	$value
bool	$prefixAlias

Return Value

string

string columnize(array $columns)

Convert an array of column names into a delimited string.

Parameters

array

$columns

Return Value

string

string parameterize(array $values)

Create query parameter place-holders for an array.

Parameters

array

$values

Return Value

string

string parameter(mixed $value)

Get the appropriate query parameter place-holder for a value.

Parameters

mixed

$value

Return Value

string

string getValue(Expression $expression)

Get the value of a raw expression.

Parameters

Expression

$expression

Return Value

string

bool isExpression(mixed $value)

Determine if the given value is a raw expression.

Parameters

mixed

$value

Return Value

bool

string getDateFormat()

Get the format for database stored dates.

Return Value

string

string getTablePrefix()

Get the grammar's table prefix.

Return Value

string

$this setTablePrefix(string $prefix)

Set the grammar's table prefix.

Parameters

string

$prefix

Return Value

$this

array compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.

Parameters

Blueprint	$blueprint
Fluent	$command
Connection	$connection

Return Value

array

string compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

array prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

Parameters

string	$prefix
array	$values

Return Value

array

array compileChange(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.

Parameters

Blueprint	$blueprint
Fluent	$command
Connection	$connection

Return Value

array

Exceptions

RuntimeException

bool supportsSchemaTransactions()

Check if this Grammar supports schema changes wrapped in a transaction.

Return Value

bool

string compileTableExists()

Compile the query to determine if a table exists.

Return Value

string

string compileColumnExists(string $table)

Compile the query to determine the list of columns.

Parameters

string

$table

Return Value

string

string compileCreate(Blueprint $blueprint, Fluent $command)

Compile a create table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileAdd(Blueprint $blueprint, Fluent $command)

Compile a column addition table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compilePrimary(Blueprint $blueprint, Fluent $command)

Compile a primary key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileUnique(Blueprint $blueprint, Fluent $command)

Compile a unique key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileIndex(Blueprint $blueprint, Fluent $command)

Compile a plain index key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDrop(Blueprint $blueprint, Fluent $command)

Compile a drop table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropIfExists(Blueprint $blueprint, Fluent $command)

Compile a drop table (if exists) command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropPrimary(Blueprint $blueprint, Fluent $command)

Compile a drop primary key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropUnique(Blueprint $blueprint, Fluent $command)

Compile a drop unique key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropIndex(Blueprint $blueprint, Fluent $command)

Compile a drop index command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.

Parameters

Blueprint	$blueprint
Fluent	$command

Return Value

string

string compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.

Return Value

string

string compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.

Return Value

string

© Taylor Otwell
Licensed under the MIT License.
Laravel is a trademark of Taylor Otwell.
https://laravel.com/api/5.3/Illuminate/Database/Schema/Grammars/SqlServerGrammar.html