SQL STATEMENTS

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
SELECT	Retrieves data from table
INSERT INTO	Adds new rows to an existing table
COPY FROM	Imports data from a file into a table for bulk loading
COPY TO	Exports table data or specific columns to CSV files
CREATE TABLE	Creates a new table in a database with specified columns and constraints
CREATE INDEX	Creates indexes on tables to optimize query performance
DROP	Deletes database objects such as tables and indexes
SET/SHOW	Configures or displays session-level settings such as path
SHOW TABLES	Lists all tables within the current schema or database
SHOW NODES	Displays the current state of nodes in a distributed cluster
DESCRIBE	Shows detailed information about columns in a table or tables within a database