W3cubDocs

/Laravel 11

SqlServerGrammar

class SqlServerGrammar extends Grammar (View source)

Traits

CompilesJsonPaths
Macroable

Properties

static protected array $macros

The registered string macros.

 from Macroable
protected Connection $connection

The connection used for escaping values.

 from Grammar
protected string $tablePrefix

The grammar table prefix.

 from Grammar
protected string[] $modifiers

The possible column modifiers.
protected bool $transactions

If this Grammar supports schema changes wrapped in a transaction.
protected string[] $fluentCommands

The commands to be executed outside of create or alter command.
protected string[] $serials

The columns available as serials.

Methods

static void macro(string $name, object|callable $macro)

Register a custom macro.

 from Macroable
static void mixin(object $mixin, bool $replace = true)

Mix another object into the class.

 from Macroable
static bool hasMacro(string $name)

Checks if macro is registered.

 from Macroable
static void flushMacros()

Flush the existing macros.

 from Macroable
static mixed __callStatic(string $method, array $parameters)

Dynamically handle calls to the class.

 from Macroable
mixed __call(string $method, array $parameters)

Dynamically handle calls to the class.

 from Macroable
array wrapArray(array $values)

Wrap an array of values.

 from Grammar
string wrapTable(Expression|string $table)

Wrap a table in keyword identifiers.
string wrap(Expression|string $value, bool $prefixAlias = false)

Wrap a value in keyword identifiers.

 from Grammar
string wrapAliasedValue(string $value)

Wrap a value that has an alias.

 from Grammar
string wrapAliasedTable(string $value)

Wrap a table that has an alias.

 from Grammar
string wrapSegments(array $segments)

Wrap the given value segments.

 from Grammar
string wrapValue(string $value)

Wrap a single string in keyword identifiers.

 from Grammar
string wrapJsonSelector(string $value)

Wrap the given JSON selector.

 from Grammar
bool isJsonSelector(string $value)

Determine if the given string is a JSON selector.

 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 quoteString(string|array $value)

Quote the given string literal.
string escape(string|float|int|bool|null $value, bool $binary = false)

Escapes a value for safe SQL embedding.

 from Grammar
bool isExpression(mixed $value)

Determine if the given value is a raw expression.

 from Grammar
string|int|float getValue(Expression|string|int|float $expression)

Transforms expressions to their scalar types.

 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
$this setConnection(Connection $connection)

Set the grammar's database connection.

 from Grammar
array wrapJsonFieldAndPath(string $column)

Split the given JSON selector into the field and the optional path and wrap them separately.

 from CompilesJsonPaths
string wrapJsonPath(string $value, string $delimiter = '->')

Wrap the given JSON path.

 from CompilesJsonPaths
string wrapJsonPathSegment(string $segment)

Wrap the given JSON path segment.

 from CompilesJsonPaths
void compileCreateDatabase(string $name, Connection $connection)

Compile a create database command.
void compileDropDatabaseIfExists(string $name)

Compile a drop database if exists command.
array|string compileRenameColumn(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a rename column command.
array|string compileChange(Blueprint $blueprint, Fluent $command, Connection $connection)

Compile a change column command into a series of SQL statements.
string compileFulltext(Blueprint $blueprint, Fluent $command)

Compile a fulltext index key command.

 from Grammar
string compileDropFullText(Blueprint $blueprint, Fluent $command)

Compile a drop fulltext index command.

 from Grammar
string compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key command.

 from Grammar
string compileDropForeign(Blueprint $blueprint, Fluent $command)

Compile a drop foreign key command.
array getColumns(Blueprint $blueprint)

Compile the blueprint's added column definitions.

 from Grammar
string getColumn(Blueprint $blueprint, ColumnDefinition $column)

Compile the column definition.

 from Grammar
string getType(Fluent $column)

Get the SQL for the column data type.

 from Grammar
void typeComputed(Fluent $column)

Create the column definition for a generated, computed column type.
string addModifiers(string $sql, Blueprint $blueprint, Fluent $column)

Add the column modifiers to the definition.

 from Grammar
Fluent|null getCommandByName(Blueprint $blueprint, string $name)

Get the command with a given name if it exists on the blueprint.

 from Grammar
array getCommandsByName(Blueprint $blueprint, string $name)

Get all of the commands with a given name.

 from Grammar
hasCommand(Blueprint $blueprint, $name)

No description

 from Grammar
array prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

 from Grammar
string getDefaultValue(mixed $value)

Format a value so that it can be used in "default" clauses.

 from Grammar
array getFluentCommands()

Get the fluent commands for the grammar.

 from Grammar
bool supportsSchemaTransactions()

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

 from Grammar
string compileDefaultSchema()

Compile a query to determine the name of the default schema.
string compileTables()

Compile the query to determine the tables.
string compileViews()

Compile the query to determine the views.
string compileColumns(string $schema, string $table)

Compile the query to determine the columns.
string compileIndexes(string $schema, string $table)

Compile the query to determine the indexes.
string compileForeignKeys(string $schema, string $table)

Compile the query to determine the foreign keys.
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 compileSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a spatial index key command.
string|null compileDefault(Blueprint $blueprint, Fluent $command)

Compile a default 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 compileDropAllTables()

Compile the SQL needed to drop all tables.
string compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.
string compileDropDefaultConstraint(Blueprint $blueprint, Fluent $command)

Compile a drop default constraint 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 compileDropSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a drop spatial index command.
string compileRename(Blueprint $blueprint, Fluent $command)

Compile a rename table command.
string compileRenameIndex(Blueprint $blueprint, Fluent $command)

Compile a rename index command.
string compileEnableForeignKeyConstraints()

Compile the command to enable foreign key constraints.
string compileDisableForeignKeyConstraints()

Compile the command to disable foreign key constraints.
string compileDropAllForeignKeys()

Compile the command to drop all foreign keys.
string compileDropAllViews()

Compile the command to drop all views.
string typeChar(Fluent $column)

Create the column definition for a char type.
string typeString(Fluent $column)

Create the column definition for a string type.
string typeTinyText(Fluent $column)

Create the column definition for a tiny text type.
string typeText(Fluent $column)

Create the column definition for a text type.
string typeMediumText(Fluent $column)

Create the column definition for a medium text type.
string typeLongText(Fluent $column)

Create the column definition for a long text type.
string typeInteger(Fluent $column)

Create the column definition for an integer type.
string typeBigInteger(Fluent $column)

Create the column definition for a big integer type.
string typeMediumInteger(Fluent $column)

Create the column definition for a medium integer type.
string typeTinyInteger(Fluent $column)

Create the column definition for a tiny integer type.
string typeSmallInteger(Fluent $column)

Create the column definition for a small integer type.
string typeFloat(Fluent $column)

Create the column definition for a float type.
string typeDouble(Fluent $column)

Create the column definition for a double type.
string typeDecimal(Fluent $column)

Create the column definition for a decimal type.
string typeBoolean(Fluent $column)

Create the column definition for a boolean type.
string typeEnum(Fluent $column)

Create the column definition for an enumeration type.
string typeJson(Fluent $column)

Create the column definition for a json type.
string typeJsonb(Fluent $column)

Create the column definition for a jsonb type.
string typeDate(Fluent $column)

Create the column definition for a date type.
string typeDateTime(Fluent $column)

Create the column definition for a date-time type.
string typeDateTimeTz(Fluent $column)

Create the column definition for a date-time (with time zone) type.
string typeTime(Fluent $column)

Create the column definition for a time type.
string typeTimeTz(Fluent $column)

Create the column definition for a time (with time zone) type.
string typeTimestamp(Fluent $column)

Create the column definition for a timestamp type.
string typeTimestampTz(Fluent $column)

Create the column definition for a timestamp (with time zone) type.
string typeYear(Fluent $column)

Create the column definition for a year type.
string typeBinary(Fluent $column)

Create the column definition for a binary type.
string typeUuid(Fluent $column)

Create the column definition for a uuid type.
string typeIpAddress(Fluent $column)

Create the column definition for an IP address type.
string typeMacAddress(Fluent $column)

Create the column definition for a MAC address type.
string typeGeometry(Fluent $column)

Create the column definition for a spatial Geometry type.
string typeGeography(Fluent $column)

Create the column definition for a spatial Geography type.
string|null modifyCollate(Blueprint $blueprint, Fluent $column)

Get the SQL for a collation column modifier.
string|null modifyNullable(Blueprint $blueprint, Fluent $column)

Get the SQL for a nullable column modifier.
string|null modifyDefault(Blueprint $blueprint, Fluent $column)

Get the SQL for a default column modifier.
string|null modifyIncrement(Blueprint $blueprint, Fluent $column)

Get the SQL for an auto-increment column modifier.
string|null modifyPersisted(Blueprint $blueprint, Fluent $column)

Get the SQL for a generated stored column modifier.

Details

static void macro(string $name, object|callable $macro)

Register a custom macro.

Parameters

string $name
object|callable $macro

Return Value

void

static void mixin(object $mixin, bool $replace = true)

Mix another object into the class.

Parameters

object $mixin
bool $replace

Return Value

void

Exceptions

ReflectionException

static bool hasMacro(string $name)

Checks if macro is registered.

Parameters

string $name

Return Value

bool

static void flushMacros()

Flush the existing macros.

Return Value

void

static mixed __callStatic(string $method, array $parameters)

Dynamically handle calls to the class.

Parameters

string $method
array $parameters

Return Value

mixed

Exceptions

BadMethodCallException

mixed __call(string $method, array $parameters)

Dynamically handle calls to the class.

Parameters

string $method
array $parameters

Return Value

mixed

Exceptions

BadMethodCallException

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

protected string wrapAliasedValue(string $value)

Wrap a value that has an alias.

Parameters

string $value

Return Value

string

protected string wrapAliasedTable(string $value)

Wrap a table that has an alias.

Parameters

string $value

Return Value

string

protected string wrapSegments(array $segments)

Wrap the given value segments.

Parameters

array $segments

Return Value

string

protected string wrapValue(string $value)

Wrap a single string in keyword identifiers.

Parameters

string $value

Return Value

string

protected string wrapJsonSelector(string $value)

Wrap the given JSON selector.

Parameters

string $value

Return Value

string

Exceptions

RuntimeException

protected bool isJsonSelector(string $value)

Determine if the given string is a JSON selector.

Parameters

string $value

Return Value

bool

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 quoteString(string|array $value)

Quote the given string literal.

Parameters

string|array $value

Return Value

string

string escape(string|float|int|bool|null $value, bool $binary = false)

Escapes a value for safe SQL embedding.

Parameters

string|float|int|bool|null $value
bool $binary

Return Value

string

bool isExpression(mixed $value)

Determine if the given value is a raw expression.

Parameters

mixed $value

Return Value

bool

string|int|float getValue(Expression|string|int|float $expression)

Transforms expressions to their scalar types.

Parameters

Expression|string|int|float $expression

Return Value

string|int|float

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

$this setConnection(Connection $connection)

Set the grammar's database connection.

Parameters

Connection $connection

Return Value

$this

protected array wrapJsonFieldAndPath(string $column)

Split the given JSON selector into the field and the optional path and wrap them separately.

Parameters

string $column

Return Value

array

protected string wrapJsonPath(string $value, string $delimiter = '->')

Wrap the given JSON path.

Parameters

string $value
string $delimiter

Return Value

string

protected string wrapJsonPathSegment(string $segment)

Wrap the given JSON path segment.

Parameters

string $segment

Return Value

string

void compileCreateDatabase(string $name, Connection $connection)

Compile a create database command.

Parameters

string $name
Connection $connection

Return Value

void

void compileDropDatabaseIfExists(string $name)

Compile a drop database if exists command.

Parameters

string $name

Return Value

void

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

Compile a rename column command.

Parameters

Blueprint $blueprint
Fluent $command
Connection $connection

Return Value

array|string

array|string 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|string

Exceptions

RuntimeException

string compileFulltext(Blueprint $blueprint, Fluent $command)

Compile a fulltext index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

Exceptions

RuntimeException

string compileDropFullText(Blueprint $blueprint, Fluent $command)

Compile a drop fulltext index command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

Exceptions

RuntimeException

string compileForeign(Blueprint $blueprint, Fluent $command)

Compile a foreign key 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

protected array getColumns(Blueprint $blueprint)

Compile the blueprint's added column definitions.

Parameters

Blueprint $blueprint

Return Value

array

protected string getColumn(Blueprint $blueprint, ColumnDefinition $column)

Compile the column definition.

Parameters

Blueprint $blueprint
ColumnDefinition $column

Return Value

string

protected string getType(Fluent $column)

Get the SQL for the column data type.

Parameters

Fluent $column

Return Value

string

protected void typeComputed(Fluent $column)

Create the column definition for a generated, computed column type.

Parameters

Fluent $column

Return Value

void

protected string addModifiers(string $sql, Blueprint $blueprint, Fluent $column)

Add the column modifiers to the definition.

Parameters

string $sql
Blueprint $blueprint
Fluent $column

Return Value

string

protected Fluent|null getCommandByName(Blueprint $blueprint, string $name)

Get the command with a given name if it exists on the blueprint.

Parameters

Blueprint $blueprint
string $name

Return Value

Fluent|null

protected array getCommandsByName(Blueprint $blueprint, string $name)

Get all of the commands with a given name.

Parameters

Blueprint $blueprint
string $name

Return Value

array

protected hasCommand(Blueprint $blueprint, $name)

No description

Parameters

Blueprint $blueprint
$name

array prefixArray(string $prefix, array $values)

Add a prefix to an array of values.

Parameters

string $prefix
array $values

Return Value

array

protected string getDefaultValue(mixed $value)

Format a value so that it can be used in "default" clauses.

Parameters

mixed $value

Return Value

string

array getFluentCommands()

Get the fluent commands for the grammar.

Return Value

array

bool supportsSchemaTransactions()

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

Return Value

bool

string compileDefaultSchema()

Compile a query to determine the name of the default schema.

Return Value

string

string compileTables()

Compile the query to determine the tables.

Return Value

string

string compileViews()

Compile the query to determine the views.

Return Value

string

string compileColumns(string $schema, string $table)

Compile the query to determine the columns.

Parameters

string $schema
string $table

Return Value

string

string compileIndexes(string $schema, string $table)

Compile the query to determine the indexes.

Parameters

string $schema
string $table

Return Value

string

string compileForeignKeys(string $schema, string $table)

Compile the query to determine the foreign keys.

Parameters

string $schema
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 compileSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a spatial index key command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string|null compileDefault(Blueprint $blueprint, Fluent $command)

Compile a default command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string|null

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 compileDropAllTables()

Compile the SQL needed to drop all tables.

Return Value

string

string compileDropColumn(Blueprint $blueprint, Fluent $command)

Compile a drop column command.

Parameters

Blueprint $blueprint
Fluent $command

Return Value

string

string compileDropDefaultConstraint(Blueprint $blueprint, Fluent $command)

Compile a drop default constraint 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 compileDropSpatialIndex(Blueprint $blueprint, Fluent $command)

Compile a drop spatial index 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 compileRenameIndex(Blueprint $blueprint, Fluent $command)

Compile a rename index 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

string compileDropAllForeignKeys()

Compile the command to drop all foreign keys.

Return Value

string

string compileDropAllViews()

Compile the command to drop all views.

Return Value

string

protected string typeChar(Fluent $column)

Create the column definition for a char type.

Parameters

Fluent $column

Return Value

string

protected string typeString(Fluent $column)

Create the column definition for a string type.

Parameters

Fluent $column

Return Value

string

protected string typeTinyText(Fluent $column)

Create the column definition for a tiny text type.

Parameters

Fluent $column

Return Value

string

protected string typeText(Fluent $column)

Create the column definition for a text type.

Parameters

Fluent $column

Return Value

string

protected string typeMediumText(Fluent $column)

Create the column definition for a medium text type.

Parameters

Fluent $column

Return Value

string

protected string typeLongText(Fluent $column)

Create the column definition for a long text type.

Parameters

Fluent $column

Return Value

string

protected string typeInteger(Fluent $column)

Create the column definition for an integer type.

Parameters

Fluent $column

Return Value

string

protected string typeBigInteger(Fluent $column)

Create the column definition for a big integer type.

Parameters

Fluent $column

Return Value

string

protected string typeMediumInteger(Fluent $column)

Create the column definition for a medium integer type.

Parameters

Fluent $column

Return Value

string

protected string typeTinyInteger(Fluent $column)

Create the column definition for a tiny integer type.

Parameters

Fluent $column

Return Value

string

protected string typeSmallInteger(Fluent $column)

Create the column definition for a small integer type.

Parameters

Fluent $column

Return Value

string

protected string typeFloat(Fluent $column)

Create the column definition for a float type.

Parameters

Fluent $column

Return Value

string

protected string typeDouble(Fluent $column)

Create the column definition for a double type.

Parameters

Fluent $column

Return Value

string

protected string typeDecimal(Fluent $column)

Create the column definition for a decimal type.

Parameters

Fluent $column

Return Value

string

protected string typeBoolean(Fluent $column)

Create the column definition for a boolean type.

Parameters

Fluent $column

Return Value

string

protected string typeEnum(Fluent $column)

Create the column definition for an enumeration type.

Parameters

Fluent $column

Return Value

string

protected string typeJson(Fluent $column)

Create the column definition for a json type.

Parameters

Fluent $column

Return Value

string

protected string typeJsonb(Fluent $column)

Create the column definition for a jsonb type.

Parameters

Fluent $column

Return Value

string

protected string typeDate(Fluent $column)

Create the column definition for a date type.

Parameters

Fluent $column

Return Value

string

protected string typeDateTime(Fluent $column)

Create the column definition for a date-time type.

Parameters

Fluent $column

Return Value

string

protected string typeDateTimeTz(Fluent $column)

Create the column definition for a date-time (with time zone) type.

Parameters

Fluent $column

Return Value

string

protected string typeTime(Fluent $column)

Create the column definition for a time type.

Parameters

Fluent $column

Return Value

string

protected string typeTimeTz(Fluent $column)

Create the column definition for a time (with time zone) type.

Parameters

Fluent $column

Return Value

string

protected string typeTimestamp(Fluent $column)

Create the column definition for a timestamp type.

Parameters

Fluent $column

Return Value

string

protected string typeTimestampTz(Fluent $column)

Create the column definition for a timestamp (with time zone) type.

Parameters

Fluent $column

Return Value

string

protected string typeYear(Fluent $column)

Create the column definition for a year type.

Parameters

Fluent $column

Return Value

string

protected string typeBinary(Fluent $column)

Create the column definition for a binary type.

Parameters

Fluent $column

Return Value

string

protected string typeUuid(Fluent $column)

Create the column definition for a uuid type.

Parameters

Fluent $column

Return Value

string

protected string typeIpAddress(Fluent $column)

Create the column definition for an IP address type.

Parameters

Fluent $column

Return Value

string

protected string typeMacAddress(Fluent $column)

Create the column definition for a MAC address type.

Parameters

Fluent $column

Return Value

string

protected string typeGeometry(Fluent $column)

Create the column definition for a spatial Geometry type.

Parameters

Fluent $column

Return Value

string

protected string typeGeography(Fluent $column)

Create the column definition for a spatial Geography type.

Parameters

Fluent $column

Return Value

string

protected string|null modifyCollate(Blueprint $blueprint, Fluent $column)

Get the SQL for a collation column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

protected string|null modifyNullable(Blueprint $blueprint, Fluent $column)

Get the SQL for a nullable column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

protected string|null modifyDefault(Blueprint $blueprint, Fluent $column)

Get the SQL for a default column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

protected string|null modifyIncrement(Blueprint $blueprint, Fluent $column)

Get the SQL for an auto-increment column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

protected string|null modifyPersisted(Blueprint $blueprint, Fluent $column)

Get the SQL for a generated stored column modifier.

Parameters

Blueprint $blueprint
Fluent $column

Return Value

string|null

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