SQL statements are the commands used to interact with Oxla database. These statements enable you to create, modify, query and manage database objects and data efficiently. The following table summarizes the statements supported by Oxla:
Statement Name
Description
SELECTRetrieves data from table
INSERT INTOAdds new rows to an existing table
COPY FROMImports data from a file into a table for bulk loading
COPY TOExports table data or specific columns to CSV files
CREATE TABLECreates a new table in a database with specified columns and constraints
CREATE INDEXCreates indexes on tables to optimize query performance
DROPDeletes database objects such as tables and indexes
SET/SHOWConfigures or displays session-level settings such as path
SHOW TABLESLists all tables within the current schema or database
SHOW NODESDisplays the current state of nodes in a distributed cluster
DESCRIBEShows detailed information about columns in a table or tables within a database