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 $defaultStringLength The default string length for migrations. from Builder

Methods

void
__construct(Connection $connection)

Create a new database Schema manager.

from Builder
static void
defaultStringLength(int $length)

Set the default string length for migrations.

from Builder
bool
hasTable(string $table)

Determine if the given table exists.

from Builder
bool
hasColumn(string $table, string $column)

Determine if the given table has a given column.

from Builder
bool
hasColumns(string $table, array $columns)

Determine if the given table has given columns.

from Builder
string
getColumnType(string $table, string $column)

Get the data type for the given column name.

from Builder
array
getColumnListing(string $table)

Get the column listing for a given table.

from Builder
void
table(string $table, Closure $callback)

Modify a table on the schema.

from Builder
void
create(string $table, Closure $callback)

Create a new table on the schema.

from Builder
void
drop(string $table)

Drop a table from the schema.

from Builder
void
dropIfExists(string $table)

Drop a table from the schema if it exists.

from Builder
void
dropAllTables()

Drop all tables from the database.

void
dropAllViews()

Drop all views from the database.

from Builder
void
rename(string $from, string $to)

Rename a table on the schema.

from Builder
bool
enableForeignKeyConstraints()

Enable foreign key constraints.

from Builder
bool
disableForeignKeyConstraints()

Disable foreign key constraints.

from Builder
void
build(Blueprint $blueprint)

Execute the blueprint to build / modify the table.

from Builder
createBlueprint(string $table, Closure $callback = null)

Create a new command set with a Closure.

from Builder
getConnection()

Get the database connection instance.

from Builder
$this
setConnection(Connection $connection)

Set the database connection instance.

from Builder
void
blueprintResolver(Closure $resolver)

Set the Schema Blueprint resolver callback.

from Builder

Details

void __construct(Connection $connection)

Create a new database Schema manager.

Parameters

Connection $connection

Return Value

void

static void defaultStringLength(int $length)

Set the default string length for migrations.

Parameters

int $length

Return Value

void

bool hasTable(string $table)

Determine if the given table exists.

Parameters

string $table

Return Value

bool

bool hasColumn(string $table, string $column)

Determine if the given table has a given column.

Parameters

string $table
string $column

Return Value

bool

bool hasColumns(string $table, array $columns)

Determine if the given table has given columns.

Parameters

string $table
array $columns

Return Value

bool

string getColumnType(string $table, string $column)

Get the data type for the given column name.

Parameters

string $table
string $column

Return Value

string

array getColumnListing(string $table)

Get the column listing for a given table.

Parameters

string $table

Return Value

array

void table(string $table, Closure $callback)

Modify a table on the schema.

Parameters

string $table
Closure $callback

Return Value

void

void create(string $table, Closure $callback)

Create a new table on the schema.

Parameters

string $table
Closure $callback

Return Value

void

void drop(string $table)

Drop a table from the schema.

Parameters

string $table

Return Value

void

void dropIfExists(string $table)

Drop a table from the schema if it exists.

Parameters

string $table

Return Value

void

void dropAllTables()

Drop all tables from the database.

Return Value

void

void dropAllViews()

Drop all views from the database.

Return Value

void

Exceptions

LogicException

void rename(string $from, string $to)

Rename a table on the schema.

Parameters

string $from
string $to

Return Value

void

bool enableForeignKeyConstraints()

Enable foreign key constraints.

Return Value

bool

bool disableForeignKeyConstraints()

Disable foreign key constraints.

Return Value

bool

protected void build(Blueprint $blueprint)

Execute the blueprint to build / modify the table.

Parameters

Blueprint $blueprint

Return Value

void

protected Blueprint createBlueprint(string $table, Closure $callback = null)

Create a new command set with a Closure.

Parameters

string $table
Closure $callback

Return Value

Blueprint

Connection getConnection()

Get the database connection instance.

Return Value

Connection

$this setConnection(Connection $connection)

Set the database connection instance.

Parameters

Connection $connection

Return Value

$this

void blueprintResolver(Closure $resolver)

Set the Schema Blueprint resolver callback.

Parameters

Closure $resolver

Return Value

void