1.1

SELECT * FROM Flightavailability where flight_date >
CURRENT_DATE;
CURRENT ISOLATION function
CURRENT ISOLATION returns the current isolation level as a char(2) value of either ""(blank), "UR", "CS",
"RS", or "RR".
Syntax
CURRENT ISOLATION
Example
VALUES CURRENT ISOLATION
CURRENT_ROLE function
CURRENT_ROLE returns the authorization identifier of the current role. If there is no current role, it returns
NULL.
This function returns a string of up to 258 characters. This is twice the length of an identifier (128*2) + 2, to
allow for quoting.
Syntax
CURRENT_ROLE
Example
VALUES CURRENT_ROLE
CURRENT SCHEMA function
CURRENT SCHEMA returns the schema name used to qualify unqualified database object references.
Note: CURRENT SCHEMA and CURRENT SQLID are synonyms.
These functions return a string of up to 128 characters.
Syntax
CURRENT SCHEMA
-- or, alternately:
CURRENT SQLID
Example
-- Set the name column default to the current schema:
CREATE TABLE mytable (id int, name VARCHAR(128) DEFAULT
553
SQL Language Reference