Class

SqlsrvPlatform

class SqlsrvPlatform extends MssqlPlatform

MS SQL Server using pdo_sqlsrv implementation.

Methods

int getMaxColumnNameLength()

string getNullString($notNull)

from MssqlPlatform
boolean supportsNativeDeleteTrigger()

Whether RDBMS supports native ON DELETE triggers (e.g.

from MssqlPlatform
boolean supportsInsertNullPk()

Whether RDBMS supports INSERT null values in autoincremented primary keys

from MssqlPlatform
string getDropTableDDL(Table $table)

Builds the DDL SQL to drop a table

from MssqlPlatform
string getPrimaryKeyDDL(Table $table)

Returns the SQL for the primary key of a Table object

from MssqlPlatform
string getAddForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL to add a foreign key.

from MssqlPlatform
string getForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL for a ForeignKey object.

from MssqlPlatform
boolean supportsSchemas()

from MssqlPlatform
boolean hasSize(string $sqlType)

Returns if the RDBMS-specific SQL type has a size attribute.

from MssqlPlatform
string quoteIdentifier(string $text)

Quotes identifiers used in database SQL.

from MssqlPlatform
string getTimestampFormatter()

Gets the preferred timestamp formatter for setting date/time values.

from MssqlPlatform

Details

at line 25
public int getMaxColumnNameLength()

Return Value

int The max column length

See also

Platform#getMaxColumnNameLength()

in MssqlPlatform at line 56
public string getNullString($notNull)

Parameters

$notNull

Return Value

string The RDBMS-specific SQL fragment for NULL or NOT NULL.

in MssqlPlatform at line 61
public boolean supportsNativeDeleteTrigger()

Whether RDBMS supports native ON DELETE triggers (e.g.

ON DELETE CASCADE).

Return Value

boolean

in MssqlPlatform at line 66
public boolean supportsInsertNullPk()

Whether RDBMS supports INSERT null values in autoincremented primary keys

Return Value

boolean

in MssqlPlatform at line 71
public string getDropTableDDL(Table $table)

Builds the DDL SQL to drop a table

Parameters

Table $table

Return Value

string

in MssqlPlatform at line 113
public string getPrimaryKeyDDL(Table $table)

Returns the SQL for the primary key of a Table object

Parameters

Table $table

Return Value

string

in MssqlPlatform at line 125
public string getAddForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL to add a foreign key.

Parameters

ForeignKey $fk

Return Value

string

in MssqlPlatform at line 143
public string getForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL for a ForeignKey object.

Parameters

ForeignKey $fk

Return Value

string

in MssqlPlatform at line 168
public boolean supportsSchemas()

Return Value

boolean

See also

Platform::supportsSchemas()

in MssqlPlatform at line 173
public boolean hasSize(string $sqlType)

Returns if the RDBMS-specific SQL type has a size attribute.

Parameters

string $sqlType the SQL type

Return Value

boolean True if the type has a size attribute

in MssqlPlatform at line 178
public string quoteIdentifier(string $text)

Quotes identifiers used in database SQL.

Parameters

string $text

Return Value

string Quoted identifier.

in MssqlPlatform at line 183
public string getTimestampFormatter()

Gets the preferred timestamp formatter for setting date/time values.

Return Value

string