| Reference Manual: SAP DB 7.2 and 7.3 |
| Concepts |
| Data Type |
| NULL value |
| Special NULL value |
| Character string |
| LONG column |
| Number |
| Date value |
| Time value |
| Timestamp value |
| BOOLEAN |
| Code Attribute |
| UNICODE |
| Code tables |
| ASCII code |
| EBCDIC code |
| SERIAL |
| Parameter |
| Table |
| Column |
| Domain |
| Index |
| Synonym |
| Users and Usergroups |
| Privilege |
| Role |
| Database Catalog/User Data |
| Transaction |
| Subtransaction |
| Database Session |
| Data integrity |
| Database procedure |
| Trigger |
| SQL mode |
| Basic elements |
| Character |
| Digit |
| Letter |
| Extended letter |
| hex_digit |
| Language-specific character |
| Special character |
| Literal |
| String literal |
| hex_literal |
| hex_digit_seq |
| Numeric literal |
| Fixed point literal |
| Sign |
| Digit sequence |
| Floating point literal |
| Mantissa |
| Exponent |
| Unsigned integer |
| Integer |
| Token |
| Regular token |
| Keyword |
| Not reserved keyword |
| Reserved keyword |
| Identifier |
| Simple identifier |
| First character |
| Identifier tail character |
| Underscore |
| Double quotes |
| Special identifier |
| Delimiter token |
| Names |
| Alias name |
| Usergroup name |
| User name |
| Constraint name |
| Name of a database procedure (dbproc_name) |
| Domain name |
| Owner |
| Result table name |
| Index name |
| Indicator name |
| MapChar Set Name (mapchar_set_name) |
| Password |
| Parameter name |
| Privilege type (privilege) |
| Name of a referential constraint (referential_constraint_name) |
| Reference name |
| Role name |
| Sequence name |
| Column name |
| Synonym name |
| Table name |
| Terminal character set name (termchar set name) |
| Trigger name |
| Column specification (column_spec) |
| Parameter specification (parameter spec) |
| Specifying values (extended value spec) |
| Specifying values (value spec) |
| Date and time format (datetimeformat) |
| Specifying a string (string spec) |
| Specifying a key (key_spec) |
| Function (function_spec) |
| Arithmetic function |
| ABS(a) |
| CEIL(a) |
| EXP(a) |
| FIXED(a,p,s) |
| FLOAT(a,s) |
| FLOOR(a) |
| INDEX(a,b,p,s) |
| LENGTH(a) |
| LN(a) |
| LOG(a,b) |
| NOROUND(a) |
| PI |
| POWER(a,n) |
| ROUND(a,n) |
| SIGN(a) |
| SQRT(a) |
| TRUNC(a,n) |
| Trigonometric function |
| String function |
| ALPHA(x,n) |
| ASCII/EBCDIC(x) |
| EXPAND(x,n) |
| INITCAP(x) |
| LFILL(x,a,n) |
| LPAD(x,a,y,n) |
| LTRIM(x,y) |
| MAPCHAR(x,n,i) |
| REPLACE(x,y,z) |
| RFILL(x,a,n) |
| RPAD(x,a,y,n) |
| RTRIM(x,y) |
| SOUNDEX(x) |
| SUBSTR(x,a,b) |
| TRANSLATE(x,y,z) |
| TRIM(x,y) |
| UPPER/LOWER(x) |
| Concatenation |
| Date function |
| ADDDATE/SUBDATE(t,a) |
| DATEDIFF(t,s) |
| DAYNAME/MONTHNAME(t) |
| DAYOFWEEK/WEEKOFYEAR/DAYOFMONTH/DAYOFYEAR(t) |
| MAKEDATE(a,b) |
| date_or_timestamp_expression |
| Time function |
| ADDTIME/SUBTIME(t,a) |
| MAKETIME(h,m,s) |
| TIMEDIFF(t,s) |
| hours/minutes/seconds |
| Time expression |
| Time or timestamp expression |
| Extraction function |
| DATE(a) |
| HOUR/MINUTE/SECOND(t) |
| MICROSECOND(a) |
| TIME(a) |
| TIMESTAMP(a,b) |
| YEAR/MONTH/DAY(t) |
| Special function |
| DECODE(x,y(i),...,z) |
| GREATEST/LEAST(x,y,...) |
| VALUE(x,y,...) |
| Conversion function |
| CHAR(a,t) |
| CHR(a,n) |
| HEX(a) |
| NUM(a) |
| Model tables |
| customer |
| hotel |
| room |
| reservation |
| Set function (set_function_spec) |
| DISTINCT function |
| ALL function |
| Set function name |
| AVG |
| COUNT |
| MAX/MIN |
| STDDEV |
| SUM |
| VARIANCE |
| Expression |
| factor |
| Predicate |
| BETWEEN predicate |
| Boolean predicate (bool_predicate) |
| Comparison predicate |
| Comparison operators (comp_op) |
| Comparison operators (equal_or_not) |
| DEFAULT predicate |
| EXISTS predicate |
| IN predicate |
| JOIN predicate |
| LIKE Predicate |
| Pattern element |
| Match string |
| Match set |
| NULL predicate |
| Quantified predicate |
| Quantifier |
| ROWNO predicate |
| SOUNDS predicate |
| Search Condition (search_condition) |
| Boolean factor |
| SQL statement: overview |
| Comment (sql_comment) |
| Data definition |
| CREATE TABLE statement |
| SAMPLE definition |
| Column definition |
| Data type |
| CHAR[ACTER] |
| VARCHAR |
| LONG[VARCHAR] |
| BOOLEAN |
| FIXED |
| FLOAT |
| INT[EGER] |
| SMALLINT |
| DATE |
| TIME |
| TIMESTAMP |
| Memory requirements of a column value per data types |
| Column attributes |
| DEFAULT specification(default_spec) |
| CONSTRAINT definition |
| Referential CONSTRAINT definition |
| DELETE rule |
| CASCADE dependency |
| Reference cycle |
| Matching row |
| Key definition |
| UNIQUE definition |
| DROP TABLE statement |
| CASCADE option |
| ALTER TABLE statement |
| ADD definition |
| ALTER definition |
| COLUMN change definition |
| DROP definition |
| MODIFY definition |
| RENAME TABLE statement |
| RENAME COLUMN statement |
| EXISTS TABLE statement |
| CREATE DOMAIN statement |
| DROP DOMAIN statement |
| CREATE SEQUENCE statement |
| DROP SEQUENCE statement |
| CREATE SYNONYM statement |
| DROP SYNONYM statement |
| RENAME SYNONYM statement |
| CREATE VIEW statement |
| Complex view table |
| Updateable View Table |
| INSERT privilege for the owner of the view table |
| UPDATE privilege for the owner of the view table |
| DELETE privilege for the owner of the view table |
| Updateable join view table |
| DROP VIEW statement |
| RENAME VIEW statement |
| CREATE INDEX statement |
| DROP INDEX statement |
| ALTER INDEX statement |
| RENAME INDEX statement |
| COMMENT ON statement |
| CREATE DBPROC statement |
| Routine |
| statement |
| DROP DBPROC statement |
| CREATE TRIGGER Statement |
| DROP TRIGGER statement |
| Authorization |
| CREATE USER statement |
| User mode |
| CREATE USERGROUP statement |
| Usergroup name |
| DROP USER statement |
| DROP USERGROUP statement |
| ALTER USER statement |
| ALTER USERGROUP statement |
| RENAME USER statement |
| RENAME USERGROUP statement |
| GRANT USER statement |
| GRANT USERGROUP statement |
| ALTER PASSWORD statement |
| CREATE ROLE statement |
| DROP ROLE statement |
| GRANT statement |
| Privilege specification (priv_spec) |
| grantee |
| REVOKE statement |
| Data manipulation |
| INSERT statement |
| Data type of the target column and inserted value |
| Join View Table in INSERT Statement |
| QUERY Expression in INSERT Statement |
| DUPLICATES clause |
| Constraint Definition in INSERT Statement |
| Trigger in INSERT Statement |
| Syntax Extension of INSERT Statement |
| Extended expression |
| SET INSERT clause |
| UPDATE Statement |
| SET UPDATE clause |
| Column combination for a given column of a join view table |
| DELETE statement |
| NEXT STAMP statement |
| CALL statement |
| Data query |
| QUERY statement |
| Named/unnamed result table |
| DECLARE CURSOR statement |
| Recursive DECLARE CURSOR statement |
| SELECT statement (named_select_statement) |
| SELECT statement (select_statement) |
| QUERY expression (query expression) |
| QUERY term (query_term) |
| QUERY expression (named query expression) |
| QUERY term (named query term) |
| QUERY specification (query_spec) |
| DISTINCT function (distinct spec) |
| Selected column (select_column) |
| QUERY specification (named_query_spec) |
| Table expression |
| FROM clause |
| FROM TABLE specification (from_table_spec) |
| Joined table |
| WHERE clause |
| GROUP clause |
| HAVING clause |
| Subquery |
| Correlated subquery |
| ORDER clause |
| UPDATE clause |
| LOCK option |
| OPEN CURSOR statement |
| FETCH statement |
| CLOSE statement |
| SINGLE SELECT statement |
| SELECT DIRECT statement (select direct statement: searched) |
| SELECT DIRECT statement (select_direct_statement:_positioned) |
| SELECT ORDERED statement (select_ordered_statement:_searched) |
| Index position specification (index_pos_spec) |
| SELECT ORDERED statement (select_ordered_statement:_positioned) |
| EXPLAIN statement |
| Transactions |
| CONNECT statement |
| SET statement |
| COMMIT statement |
| ROLLBACK statement |
| SUBTRANS statement |
| LOCK statement |
| ROW specification (row spec) |
| UNLOCK statement |
| RELEASE statement |
| System Tables |
| COLUMNS |
| CONNECTEDUSERS |
| CONNECTPARAMETERS |
| CONSTRAINTS |
| DBPROCEDURES |
| DBPROCPARAMS |
| DOMAINCONSTRAINTS |
| DOMAINS |
| FOREIGNKEYCOLUMNS |
| FOREIGNKEYS |
| INDEXCOLUMNS |
| INDEXES |
| LOCKS |
| MAPCHARSETS |
| PACKAGES |
| ROLEPRIVILEGES |
| ROLES |
| SEQUENCES |
| SESSION_ROLES |
| SYNONYMS |
| TABLEPRIVILEGES |
| TABLES |
| TERMCHARSETS |
| TRIGGERPARAMS |
| TRIGGERS |
| USERS |
| VERSIONS |
| VIEWCOLUMNS |
| VIEWDEFS |
| VIEWS |
| Statistics |
| UPDATE STATISTICS statement |
| Statistical system tables |
| DATADEVSPACES |
| DBPARAMETERS |
| INDEXSTATISTICS |
| LOCKLISTSTATISTICS |
| SERVERDBSTATISTICS |
| TABLESTATISTICS |
| TRANSACTIONS |
| USERSTATISTICS |
| MONITOR statement |
| Monitor system tables |
| MONITOR_CACHES |
| MONITOR_LOAD |
| MONITOR_LOCK |
| MONITOR_LOG |
| MONITOR_PAGES |
| MONITOR_ROW |
| MONITOR_TRANS |
| MONITOR_VTRACE |
| MONITOR |
| Restrictions |
| Syntax List |
| Syntax Notation |
| add_definition |
| alias_name |
| all_function |
| alter_definition |
| alter_index_statement |
| alter_password_statement |
| alter_table_statement |
| alter_user_statement |
| alter_usergroup_statement |
| argument |
| arithmetic_function |
| assignment_statement |
| between_predicate |
| bool_predicate |
| boolean_factor |
| boolean_term |
| call_statement |
| cascade_option |
| character |
| close_statement |
| column_attributes |
| column_change_definition |
| column_definition |
| column_list |
| column_name |
| column_spec |
| comment |
| comment_on_statement |
| commit_statement |
| comp_op |
| comparison_predicate |
| connect_option |
| connect_statement |
| constraint_definition |
| constraint_name |
| conversion_function |
| create_dbproc_statement |
| create_domain_statement |
| create_index_statement |
| create_role_statement |
| create_sequence_statement |
| create_table_statement |
| create_table_temp |
| create_trigger_statement |
| create_user_statement |
| create_usergroup_statement |
| create_view_statement |
| data_type |
| date_function |
| date_or_timestamp_expression |
| datetimeformat |
| dbproc_name |
| declare_cursor_statement |
| default_predicate |
| default_spec |
| delete_rule |
| delete_statement |
| Delimiter token |
| derived_column |
| digit |
| digit_sequence |
| distinct_function |
| distinct_spec |
| domain_name |
| double_quotes |
| drop_dbproc_statement |
| drop_definition |
| drop_domain_statement |
| drop_index_statement |
| drop_role_statement |
| drop_sequence_statement |
| drop_synonym_statement |
| drop_table_statement |
| drop_trigger_statement |
| drop_user_statement |
| drop_usergroup_statement |
| drop_view_statement |
| duplicates_clause |
| equal_or_not |
| exists_predicate |
| exists_table_statement |
| explain_statement |
| exponent |
| expression |
| expression_list |
| extended_expression |
| extended_letter |
| extended_value_spec |
| extraction_function |
| factor |
| fetch_statement |
| final_select |
| first_character |
| first_password_character |
| fixed_point_literal |
| floating_point_literal |
| formal_parameter |
| from_clause |
| from_table_spec |
| function_spec |
| grant_statement |
| grant_user_statement |
| grant_usergroup_statement |
| granted_usergroups |
| granted_users |
| grantee |
| group_clause |
| having_clause |
| hex_digit |
| hex_digit_seq |
| hex_literal |
| hours |
| identifier |
| identifier_tail_character |
| if_statement |
| in_predicate |
| index_name |
| index_pos_spec |
| indicator_name |
| initial_select |
| insert_expression |
| insert_statement |
| integer |
| join_predicate |
| join_spec |
| joined_table |
| key_definition |
| key_or_not_null_spec |
| key_spec |
| key_word |
| language_specific_character |
| letter |
| like_expression |
| like_predicate |
| literal |
| local_variable |
| local_variable_list |
| local_variables |
| lock_option |
| lock_spec |
| lock_statement |
| mantissa |
| mapchar_set_name |
| match_char |
| match_class |
| match_element |
| match_range |
| Match set |
| match_string |
| minutes |
| modify_definition |
| monitor_statement |
| named_query_expression |
| named_query_primary |
| named_query_spec |
| named_query_term |
| named_select_statement |
| new_index_name |
| new_table_name |
| next_stamp_statement |
| null_predicate |
| numeric_literal |
| not_reserved_key_word |
| object_spec |
| old_index_name |
| old_table_name |
| open_cursor_statement |
| order_clause |
| outer_join_inidicator |
| owner |
| parameter_name |
| parameter_spec |
| password |
| pattern_element |
| pos_spec |
| position |
| predicate |
| priv_spec |
| privilege |
| procedure_name |
| quantified_predicate |
| quantifier |
| query_expression |
| query_primary |
| query_spec |
| query_statement |
| query_term |
| recursive_declare_cursor_statement |
| recursive_select |
| reference_name |
| referenced_column |
| referenced_table |
| referencing_column |
| referential_constraint_definition |
| referential_constraint_name |
| regular_token |
| release_statement |
| rename_column_statement |
| rename_index_statement |
| rename_synonym_statement |
| rename_table_statement |
| rename_user_statement |
| rename_usergroup_statement |
| rename_view_statement |
| reserved_key_word |
| result_column_name |
| result_table_name |
| revoke_statement |
| role_name |
| rollback_statement |
| routine |
| routine_sql_statement |
| row_spec |
| rowno_column |
| rowno_predicate |
| sample_definition |
| search_and_result_spec |
| search_condition |
| seconds |
| select_column |
| select_direct_statement:_positioned |
| select_direct_statement:_searched |
| select_ordered_format1:_positioned |
| select_ordered_format1:_searched |
| select_ordered_format2:_positioned |
| select_ordered_format2:_searched |
| select_ordered_statement:_positioned |
| select_ordered_statement:_searched |
| select_statement |
| sequence_name |
| set_function_name |
| set_function_spec |
| set_insert_clause |
| set_statement |
| set_update_clause |
| sign |
| simple_identifier |
| single_select_statement |
| sort_spec |
| sound_predicate |
| source_user |
| special_character |
| special_function |
| special_identifier |
| special_identifier_character |
| sql_comment |
| stamp_column |
| statement |
| statement_list |
| string_function |
| string_literal |
| string_spec |
| subquery |
| subtrans_statement |
| synonym_name |
| table_columns |
| table_description_element |
| table_expression |
| table_name |
| term |
| termchar_set_name |
| time_expression |
| time_or_timestamp_expression |
| time_function |
| trigger_event |
| trigger_name |
| trigonometric_function |
| underscore |
| unique_definition |
| unlock_statement |
| unsigned_integer |
| update_clause |
| update_statement |
| update_statistics_statement |
| user_mode |
| user_name |
| usergroup_mode |
| usergroup_name |
| value_spec |
| variable_name |
| where_clause |
| while_statement |