The following chapters describe the most common SQL statements for ibaAnalyzer. The examples are based on the MS SQL server syntax. Other databases (Oracle, IBM-DB2, etc.) may use different SQL syntaxes.

Categories of SQL statements

  • Data manipulation language (DML):Statements to query and manipulate data (modify, insert, delete) e.g. SELECT, INSERT, UPDATE, DELETE

  • Data definition language (DDL):Statements to define the database scheme or objectse.g. CREATE, ALTER, DROP

  • Data control language (DCL):Statements for rights managemente.g. GRANT, REVOKE, DENY