Creating Tables and Views
Was this helpful?
Was this helpful?
This method allows you to create a table object.
Argument
Type
Required
Default
Description
table
string
true
The name of the table to create.
callback
function
true
A callback function used to define the table body. It is passed a Blueprint
as the only argument.
options
struct
false
{}
Options to pass to queryExecute
.
execute
boolean
false
true
Run the query immediately after building it.
The majority of the work comes from calling methods on the Blueprint
object. A Blueprint
defines the and for your tables.
Example:
This would convert to the following SQL in MySQL:
Only one table can be created at a time. If you wanted to create multiple tables, you would call create
multiple times.
This method allows you to create a table using a query. It is similar to a view except that the data is inserted once at table creation.
This is an UnsupportedOperation
on DerbyGrammar
.
newTableName
string
true
The name of the table to create.
callback
function
true
A callback function used to define the table body. It is passed a QueryBuilder
as the only argument.
options
struct
false
{}
Options to pass to queryExecute
.
execute
boolean
false
true
Run the query immediately after building it.
Like with a view
, the columns are defined by the data returned by the query. The data returned by the query will be inserted into the table.
This method allows you to create a view using a query.
view
string
true
The name of the view to create.
callback
function
true
A callback function used to define the table body. It is passed a QueryBuilder
as the only argument.
options
struct
false
{}
Options to pass to queryExecute
.
execute
boolean
false
true
Run the query immediately after building it.
The callback
argument is where you define the schema of your table. It is passed a Blueprint
object. This is commonly aliased as table
in the callback. Blueprint
defines the field, index and constraint methods to build your table. You can find a comprehensive list of all available methods here for and here for .