An interface used by TableSchema objects.
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.
arraySQL 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.
arrayList 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.
arraySQL 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.
arraySQL 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.
arraySQL 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.1/interface-Cake.Database.Schema.SqlGeneratorInterface.html