SqlServerBuilder
class SqlServerBuilder extends Builder (View source)
Properties
| protected Connection | $connection | The database connection instance. |
from Builder |
| protected Grammar | $grammar | The schema grammar instance. |
from Builder |
| protected Closure | $resolver | The Blueprint resolver callback. |
from Builder |
| static int|null | $defaultStringLength | The default string length for migrations. |
from Builder |
| static string | $defaultMorphKeyType | The default relationship morph key type. |
from Builder |
| static bool | $alwaysUsesNativeSchemaOperationsIfPossible | Indicates whether Doctrine DBAL usage will be prevented if possible when dropping and renaming columns. |
from Builder |
Methods
Set the default string length for migrations.
Set the default morph key type for migrations.
Attempt to use native schema operations for dropping and renaming columns, even if Doctrine DBAL is installed.
Create a database in the schema.
Drop a database from the schema if the database exists.
Determine if the given table has a given column.
Determine if the given table has given columns.
Execute a table builder callback if the given table has a given column.
Execute a table builder callback if the given table doesn't have a given column.
Get the data type for the given column name.
Drop columns from a table schema.
Drop all tables from the database.
Drop all views from the database.
Drop all tables from the database.
Disable foreign key constraints during the execution of a callback.
Create a new command set with a Closure.
Get all of the view names for the database.
Details
void
__construct(Connection $connection)
Create a new database Schema manager.
static void
defaultStringLength(int $length)
Set the default string length for migrations.
static void
defaultMorphKeyType(string $type)
Set the default morph key type for migrations.
static void
morphUsingUuids()
Set the default morph key type for migrations to UUIDs.
static void
morphUsingUlids()
Set the default morph key type for migrations to ULIDs.
static void
useNativeSchemaOperationsIfPossible(bool $value = true)
Attempt to use native schema operations for dropping and renaming columns, even if Doctrine DBAL is installed.
bool
createDatabase(string $name)
Create a database in the schema.
bool
dropDatabaseIfExists(string $name)
Drop a database from the schema if the database exists.
bool
hasTable(string $table)
Determine if the given table exists.
bool
hasColumn(string $table, string $column)
Determine if the given table has a given column.
bool
hasColumns(string $table, array $columns)
Determine if the given table has given columns.
void
whenTableHasColumn(string $table, string $column, Closure $callback)
Execute a table builder callback if the given table has a given column.
void
whenTableDoesntHaveColumn(string $table, string $column, Closure $callback)
Execute a table builder callback if the given table doesn't have a given column.
string
getColumnType(string $table, string $column)
Get the data type for the given column name.
array
getColumnListing(string $table)
Get the column listing for a given table.
void
table(string $table, Closure $callback)
Modify a table on the schema.
void
create(string $table, Closure $callback)
Create a new table on the schema.
void
drop(string $table)
Drop a table from the schema.
void
dropIfExists(string $table)
Drop a table from the schema if it exists.
void
dropColumns(string $table, string|array $columns)
Drop columns from a table schema.
void
dropAllTables()
Drop all tables from the database.
void
dropAllViews()
Drop all views from the database.
void
dropAllTypes()
Drop all types from the database.
void
getAllTables()
Drop all tables from the database.
void
rename(string $from, string $to)
Rename a table on the schema.
bool
enableForeignKeyConstraints()
Enable foreign key constraints.
bool
disableForeignKeyConstraints()
Disable foreign key constraints.
mixed
withoutForeignKeyConstraints(Closure $callback)
Disable foreign key constraints during the execution of a callback.
protected void
build(Blueprint $blueprint)
Execute the blueprint to build / modify the table.
protected Blueprint
createBlueprint(string $table, Closure|null $callback = null)
Create a new command set with a Closure.
Connection
getConnection()
Get the database connection instance.
$this
setConnection(Connection $connection)
Set the database connection instance.
void
blueprintResolver(Closure $resolver)
Set the Schema Blueprint resolver callback.
array
getAllViews()
Get all of the view names for the database.