SQL statements

This section contains the list of SQL statements that watsonx.data supports.

ALTER FUNCTION statement
ALTER SCHEMA statement
The ALTER SCHEMA statement changes the definition of an existing schema.
ALTER TABLE statement
ANALYZE statement
CALL statement
COMMIT statement
CREATE FUNCTION statement
CREATE ROLE statement
CREATE SCHEMA statement
CREATE TABLE statement
The CREATE TABLE statement defines a table. The definition must include its name and the names and attributes of its columns.
CREATE TABLE AS statement
CREATE VIEW statement
DEALLOCATE PREPARE statement
DELETE statement
DESCRIBE statement
DESCRIBE INPUT statement
DESCRIBE OUTPUT statement
DROP FUNCTION statement
DROP ROLE statement
DROP SCHEMA statement
DROP TABLE statement
DROP VIEW statement
EXECUTE statement
EXPLAIN statement
EXPLAIN ANALYZE statement
GRANT statement
GRANT ROLES statement
INSERT statement
PREPARE statement
RESET SESSION statement
REVOKE statement
REVOKE ROLES statement
ROLL BACK statement
SELECT statement
SET ROLE statement
SET SESSION statement
SHOW CATALOGS statement
SHOW COLUMNS statement
SHOW CREATE FUNCTION statement
SHOW CREATE TABLE statement
SHOW CREATE VIEW statement
SHOW FUNCTIONS statement
SHOW GRANTS statement
SHOW ROLE GRANTS statement
SHOW ROLE statement
SHOW SCHEMAS statement
SHOW SESSION statement
SHOW STATS statement
SHOW TABLES statement
START TRANSACTION statement
TRUNCATE statement
USE statement
VALUES statement