Propel 2 API
Class

Propel\Generator\Platform\SqlsrvPlatform

class SqlsrvPlatform extends MssqlPlatform

MS SQL Server using pdo_sqlsrv implementation.

Methods

int getMaxColumnNameLength()

string. getNullString($notNull)

Returns the NOT NULL string for the configured RDBMS.

 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 23
public int getMaxColumnNameLength()

Return Value

int The max column length

See also

Platform#getMaxColumnNameLength()

in MssqlPlatform at line 59
public string. getNullString($notNull)

Returns the NOT NULL string for the configured RDBMS.

Parameters

$notNull

Return Value

string. The RDBMS-specific SQL fragment for <code>NULL</code> or <code>NOT NULL</code>.

in MssqlPlatform at line 64
public boolean supportsNativeDeleteTrigger()

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

ON DELETE CASCADE).

Return Value

boolean

in MssqlPlatform at line 69
public boolean supportsInsertNullPk()

Whether RDBMS supports INSERT null values in autoincremented primary keys

Return Value

boolean

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

Builds the DDL SQL to drop a table

Parameters

Table $table

Return Value

string

in MssqlPlatform at line 116
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 128
public string getAddForeignKeyDDL(ForeignKey $fk)

Builds the DDL SQL to add a foreign key.

Parameters

ForeignKey $fk

Return Value

string

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

Builds the DDL SQL for a ForeignKey object.

Parameters

ForeignKey $fk

Return Value

string

in MssqlPlatform at line 171
public boolean supportsSchemas()

Return Value

boolean

See also

Platform::supportsSchemas()

in MssqlPlatform at line 176
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 181
public string quoteIdentifier(string $text)

Quotes identifiers used in database SQL.

Parameters

string $text

Return Value

string Quoted identifier.

in MssqlPlatform at line 186
public string getTimestampFormatter()

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

Return Value

string