SQL Reference

Table Of Contents

Chapter 2 | Supported standards 23

Dropping an index for any column automatically selects the Storage Option of None and clears

Automatically create indexes as needed in Indexing for the corresponding field in the

FileMaker database file.

The PREVENT INDEX CREATION attribute is not supported.

Example

DROP INDEX ON Salespeople.Salesperson_ID

SQL expressions

Use expressions in WHERE, HAVING, and ORDER BY clauses of SELECT statements to form

detailed and sophisticated database queries. Valid expression elements are:

1 Field names

1 Constants

1 Exponential/scientific notation

1 Numeric operators

1 Character operators

1 Date operators

1 Relational operators

1 Logical operators

1 Functions

Field names

The most common expression is a simple field name, such as calc or

Sales_Data.Invoice_ID.

Constants

Constants are values that do not change. For example, in the expression PRICE * 1.05, the

value 1.05 is a constant. Or you might assign a value of 30 to the constant

Number_Of_Days_In_June.

You must enclose character constants in pairs of single quotation marks ('). To include a single

quotation mark in a character constant enclosed by single quotation marks, use two single

quotation marks together (for example, 'Don''t').

For ODBC and JDBC applications, FileMaker accepts the ODBC/JDBC format date, time, and

timestamp constants in braces ({}), for example:

1 {D '2015-06-05'}

1 {T '14:35:10'}

1 {TS '2015-06-05 14:35:10'}

FileMaker allows the type specifier (D, T, TS) to be in upper case or lower case. You may use any

number of spaces after the type specifier, or even omit the space.