Reference: SQL Statements
The complete list of supported SQL statements in CedarDB is as follows:
- Abort
- abort the transaction
- Alter role
- modify a database role
- Alter table
- modify a table definition
- Alter user
- modify a database role
- Analyze
- recompute statistics
- Begin
- start a transaction
- Call
- call a function
- Commit
- commit the transaction
- Copy
- load or store data from files
- Create database
- define a new database
- Create function
- define a new function
- Create group
- create a new database role
- Create index
- create a new index
- Create role
- create a new database role
- Create schema
- create a new namespace
- Create sequence
- define a new sequence generator
- Create table
- define a new table
- Create table as
- create and populate a new table with contents from a query
- Create user
- create a new database role
- Create view
- define a new view from a query
- Deallocate
- remove a prepared statement
- Delete
- remove rows from a table
- Discard
- reset the currently logged-in session
- Drop
- remove schema definitions
- End
- commit the transaction
- Execute
- execute a prepared statement
- Explain
- show the execution plan of a query
- Grant
- add roles to groups
- Insert
- create rows in a table
- Prepare
- define a new prepared statement
- Rename
- rename a table
- Reset
- reset a setting to the default
- Rollback
- abort the transaction
- Select
- query data from the database
- Select into
- create and populate a new table with contents from a query
- Set
- change a setting
- Show
- inspect the current value of a setting
- Start transaction
- start a transaction
- Truncate
- delete all rows of a table
- Update
- change rows of a table
- Vacuum
- perform database maintenance
- Values
- specify constant rows
