SQL language elements in syntax diagramms

( )

    Round brackets. Are used in field size definitions in logical constucts or formulas.

Alias

    Alias is an alias to the original tablename, which is used instead of the tablename.

    Example:

mytable1

Fieldname

    Fieldname is the name of an databasetable-field or -column in the used database table.

    Example:

 preis 

Feldlist

    Fieldlist is a list of fieldnames of the used database table, separated with commas.

    Example:

 onum, preis, anz 

Value

    Value is here a value that can be stored in the corresponding SQL data type, such as an integer, decimal number or text in "Hochkomma".

    Example:

 'Berlin' 

Valuelist

    Valuelist is a list of values separated with commas (see value).

    Example:

 1001, 'Müller', 'Berlin', .12 

Tablename

    Tablename is a name of an table existing or to be created in the database.

    Example:

 torder 

Logical constuct

 preis &gt 100 AND preis &lt 1000 

Formula

 ( (price * prov) - .10 )

Integer

    Integer ist a number without decimals.

    Example:

 17