Schema
This class is a utility to modify database and table schemas.
Get Current database
Change database
Check if a database exists
Find all databases
Find all databases by name:
Create a database
Create a table with custom character set and collation:
Change the database
Find all tables
Find all tables by name:
Check whether table exists
Delete all rows
Deprecated: Use DeleteQuery instead
Truncate a table
Delete all rows and reset the auto increment value:
Rename a table
Copy a table
Copy an existing table to a new table:
Get all column names of a table
Get all column details of a table
Compare tables
Compare two tables and returns true if the table schema match:
Get the table schema hash
Calculate a hash key (SHA1) using a table schema. Used to quickly compare table structures or schema versions.
Next page: Compression