SqlServerGrammar
Extends
Properties
$transactions bool
If this Grammar supports schema changes wrapped in a transaction.
$modifiers string[]
The possible column modifiers.
$serials string[]
The columns available as serials.
Methods
compileCreateDatabase ( $name , $connection ) : string
Compile a create database command.
Parameters
- $name string
- $connection Connection
compileDropDatabaseIfExists ( $name ) : string
Compile a drop database if exists command.
Parameters
- $name string
compileTableExists ( ) : string
Compile the query to determine if a table exists.
compileColumnListing ( $table ) : string
Compile the query to determine the list of columns.
Parameters
- $table string
compileCreate ( Blueprint $blueprint , Fluent $command ) : string
Compile a create table command.
Parameters
compileAdd ( Blueprint $blueprint , Fluent $command ) : string
Compile a column addition table command.
Parameters
compilePrimary ( Blueprint $blueprint , Fluent $command ) : string
Compile a primary key command.
Parameters
compileUnique ( Blueprint $blueprint , Fluent $command ) : string
Compile a unique key command.
Parameters
compileIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a plain index key command.
Parameters
compileSpatialIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a spatial index key command.
Parameters
compileDrop ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop table command.
Parameters
compileDropIfExists ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop table (if exists) command.
Parameters
compileDropAllTables ( ) : string
Compile the SQL needed to drop all tables.
compileDropColumn ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop column command.
Parameters
compileDropDefaultConstraint ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop default constraint command.
Parameters
compileDropPrimary ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop primary key command.
Parameters
compileDropUnique ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop unique key command.
Parameters
compileDropIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop index command.
Parameters
compileDropSpatialIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop spatial index command.
Parameters
compileDropForeign ( Blueprint $blueprint , Fluent $command ) : string
Compile a drop foreign key command.
Parameters
compileRename ( Blueprint $blueprint , Fluent $command ) : string
Compile a rename table command.
Parameters
compileRenameIndex ( Blueprint $blueprint , Fluent $command ) : string
Compile a rename index command.
Parameters
compileEnableForeignKeyConstraints ( ) : string
Compile the command to enable foreign key constraints.
compileDisableForeignKeyConstraints ( ) : string
Compile the command to disable foreign key constraints.
compileDropAllForeignKeys ( ) : string
Compile the command to drop all foreign keys.
compileDropAllViews ( ) : string
Compile the command to drop all views.
typeChar ( Fluent $column ) : string
Create the column definition for a char type.
Parameters
- $column Fluent
typeString ( Fluent $column ) : string
Create the column definition for a string type.
Parameters
- $column Fluent
typeTinyText ( Fluent $column ) : string
Create the column definition for a tiny text type.
Parameters
- $column Fluent
typeText ( Fluent $column ) : string
Create the column definition for a text type.
Parameters
- $column Fluent
typeMediumText ( Fluent $column ) : string
Create the column definition for a medium text type.
Parameters
- $column Fluent
typeLongText ( Fluent $column ) : string
Create the column definition for a long text type.
Parameters
- $column Fluent
typeInteger ( Fluent $column ) : string
Create the column definition for an integer type.
Parameters
- $column Fluent
typeBigInteger ( Fluent $column ) : string
Create the column definition for a big integer type.
Parameters
- $column Fluent
typeMediumInteger ( Fluent $column ) : string
Create the column definition for a medium integer type.
Parameters
- $column Fluent
typeTinyInteger ( Fluent $column ) : string
Create the column definition for a tiny integer type.
Parameters
- $column Fluent
typeSmallInteger ( Fluent $column ) : string
Create the column definition for a small integer type.
Parameters
- $column Fluent
typeFloat ( Fluent $column ) : string
Create the column definition for a float type.
Parameters
- $column Fluent
typeDouble ( Fluent $column ) : string
Create the column definition for a double type.
Parameters
- $column Fluent
typeDecimal ( Fluent $column ) : string
Create the column definition for a decimal type.
Parameters
- $column Fluent
typeBoolean ( Fluent $column ) : string
Create the column definition for a boolean type.
Parameters
- $column Fluent
typeEnum ( Fluent $column ) : string
Create the column definition for an enumeration type.
Parameters
- $column Fluent
typeJson ( Fluent $column ) : string
Create the column definition for a json type.
Parameters
- $column Fluent
typeJsonb ( Fluent $column ) : string
Create the column definition for a jsonb type.
Parameters
- $column Fluent
typeDate ( Fluent $column ) : string
Create the column definition for a date type.
Parameters
- $column Fluent
typeDateTime ( Fluent $column ) : string
Create the column definition for a date-time type.
Parameters
- $column Fluent
typeDateTimeTz ( Fluent $column ) : string
Create the column definition for a date-time (with time zone) type.
Parameters
- $column Fluent
typeTime ( Fluent $column ) : string
Create the column definition for a time type.
Parameters
- $column Fluent
typeTimeTz ( Fluent $column ) : string
Create the column definition for a time (with time zone) type.
Parameters
- $column Fluent
typeTimestamp ( Fluent $column ) : string
Create the column definition for a timestamp type.
Parameters
- $column Fluent
typeTimestampTz ( Fluent $column ) : string
Create the column definition for a timestamp (with time zone) type.
Parameters
- $column Fluent
typeYear ( Fluent $column ) : string
Create the column definition for a year type.
Parameters
- $column Fluent
typeBinary ( Fluent $column ) : string
Create the column definition for a binary type.
Parameters
- $column Fluent
typeUuid ( Fluent $column ) : string
Create the column definition for a uuid type.
Parameters
- $column Fluent
typeIpAddress ( Fluent $column ) : string
Create the column definition for an IP address type.
Parameters
- $column Fluent
typeMacAddress ( Fluent $column ) : string
Create the column definition for a MAC address type.
Parameters
- $column Fluent
typeGeometry ( Fluent $column ) : string
Create the column definition for a spatial Geometry type.
Parameters
- $column Fluent
typePoint ( Fluent $column ) : string
Create the column definition for a spatial Point type.
Parameters
- $column Fluent
typeLineString ( Fluent $column ) : string
Create the column definition for a spatial LineString type.
Parameters
- $column Fluent
typePolygon ( Fluent $column ) : string
Create the column definition for a spatial Polygon type.
Parameters
- $column Fluent
typeGeometryCollection ( Fluent $column ) : string
Create the column definition for a spatial GeometryCollection type.
Parameters
- $column Fluent
typeMultiPoint ( Fluent $column ) : string
Create the column definition for a spatial MultiPoint type.
Parameters
- $column Fluent
typeMultiLineString ( Fluent $column ) : string
Create the column definition for a spatial MultiLineString type.
Parameters
- $column Fluent
typeMultiPolygon ( Fluent $column ) : string
Create the column definition for a spatial MultiPolygon type.
Parameters
- $column Fluent
typeComputed ( Fluent $column ) : string|null
Create the column definition for a generated, computed column type.
Parameters
- $column Fluent
modifyCollate ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a collation column modifier.
Parameters
modifyNullable ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a nullable column modifier.
Parameters
modifyDefault ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a default column modifier.
Parameters
modifyIncrement ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for an auto-increment column modifier.
Parameters
modifyPersisted ( Blueprint $blueprint , Fluent $column ) : string|null
Get the SQL for a generated stored column modifier.
Parameters
wrapTable ( $table ) : string
Wrap a table in keyword identifiers.
Parameters
- $table Expression |string
quoteString ( $value ) : string
Quote the given string literal.
Parameters
- $value string|array