Drop

Dropping tables straightforward in qb.
For dropping columns or constraints, see Alter.
drop
Drop a table from the database.
Argument
Type
Required
Default
Description
table
string
true
​
The name of the table to drop.
options
struct
false
{}
Options to pass to queryExecute.
execute
boolean
false
true
Run the query immediately after building it.
Example:
SchemaBuilder
schema.drop( "user_logins" );
SQL (MySQL)
DROP TABLE `user_logins`
dropIfExists
Drop a table from the database if it exists.
Argument
Type
Required
Default
Description
table
string
true
​
The name of the table to drop.
options
struct
false
{}
Options to pass to queryExecute.
execute
boolean
false
true
Run the query immediately after building it.
Example:
SchemaBuilder
schema.dropIfExists( "user_logins" );
SQL (MySQL)
DROP TABLE IF EXISTS `user_logins`

Schema Builder - Previous

Alter

Last modified 3mo ago

Argument	Type	Required	Default	Description
table	string	`true`		The name of the table to drop.
options	struct	`false`	`{}`	Options to pass to `queryExecute`.
execute	boolean	`false`	`true`	Run the query immediately after building it.