Static SQL statements Describes static SQL statements supported in the language. Understanding static SQL statements This is an introduction to static SQL statements. Using program variables in static SQL Static SQL syntax supports the usage of program variables as SQL parameters. Table and column names in static SQL How are SQL object names and keywords converted in static SQL? SQL texts generated by the compiler The Genero BDL compiler provides an option to extract static SQL statements from .4gl sources. INSERT Creates a new row in a database table. UPDATE Modifies rows of a database table. DELETE Removes rows from a database table. SELECT Produces a result set from a query on database tables. SQL ... END SQL Performs an SQL that is not part of the static SQL syntax. CREATE SEQUENCE Creates a new sequence object in the database. ALTER SEQUENCE Modifies the definition of an existing sequence in the database. DROP SEQUENCE Drops a sequence object from the database. CREATE TABLE Creates a new table object in the database. ALTER TABLE Modifies the definition of an existing table in the database. DROP TABLE Drops a table object from the database. CREATE INDEX Creates a new index object in the database. ALTER INDEX Modifies the definition of an existing index in the database. DROP INDEX Drops an index object from the database. CREATE VIEW Creates a new view object in the database. DROP VIEW Drops a view object from the database. CREATE SYNONYM Creates a new synonym object in the database. DROP SYNONYM Drops a synonym object from the database. RENAME Renames an object in the database.