Interface SqlGeneratorInterface

An interface used by TableSchema objects.

Method Summary

addConstraintSql() public

Generate the SQL statements to add the constraints to the table
createSql() public

Generate the SQL to create the Table.
dropConstraintSql() public

Generate the SQL statements to drop the constraints to the table
dropSql() public

Generate the SQL to drop a table.
truncateSql() public

Generate the SQL statements to truncate a table

addConstraintSql(\Cake\Database\Connection $connection)

Generate the SQL statements to add the constraints to the table

\Cake\Database\Connection $connection: The connection to generate SQL for.

array

SQL to add the constraints.

createSql(\Cake\Database\Connection $connection)

Generate the SQL to create the Table.

Uses the connection to access the schema dialect to generate platform specific SQL.

\Cake\Database\Connection $connection: The connection to generate SQL for.

array

List of SQL statements to create the table and the required indexes.

dropConstraintSql(\Cake\Database\Connection $connection)

Generate the SQL statements to drop the constraints to the table

\Cake\Database\Connection $connection: The connection to generate SQL for.

array

SQL to drop a table.

dropSql(\Cake\Database\Connection $connection)

Generate the SQL to drop a table.

Uses the connection to access the schema dialect to generate platform specific SQL.

\Cake\Database\Connection $connection: The connection to generate SQL for.

array

SQL to drop a table.

truncateSql(\Cake\Database\Connection $connection)

Generate the SQL statements to truncate a table

\Cake\Database\Connection $connection: The connection to generate SQL for.

array

SQL to truncate a table.

© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/4.0/interface-Cake.Database.Schema.SqlGeneratorInterface.html