Static SQL statements Describes static SQL statements supported in the language. Understanding static SQL statementsThis is an introduction to static SQL statements.Using program variables in static SQLStatic SQL syntax supports the usage of program variables as SQL parameters.Table and column names in static SQLHow are SQL object names and keywords converted in static SQL?SQL texts generated by the compilerThe Genero BDL compiler provides an option to extract static SQL statements from .4gl sources.INSERTCreates a new row in a database table.UPDATEModifies rows of a database table.DELETERemoves rows from a database table.SELECTProduces a result set from a query on database tables.SQL ... END SQLPerforms an SQL that is not part of the static SQL syntax.CREATE SEQUENCECreates a new sequence object in the database.ALTER SEQUENCEModifies the definition of an existing sequence in the database.DROP SEQUENCEDrops a sequence object from the database.CREATE TABLECreates a new table object in the database.ALTER TABLEModifies the definition of an existing table in the database.DROP TABLEDrops a table object from the database.CREATE INDEXCreates a new index object in the database.ALTER INDEXModifies the definition of an existing index in the database.DROP INDEXDrops an index object from the database.CREATE VIEWCreates a new view object in the database.DROP VIEWDrops a view object from the database.CREATE SYNONYMCreates a new synonym object in the database.DROP SYNONYMDrops a synonym object from the database.RECOVER TABLERestores a database table.RENAMERenames an object in the database.