CURRENT SCHEMA returns the schema name used to qualify unqualified database object references.
These functions return a string of up to 128 characters.
CURRENT SCHEMA -- or, alternately: CURRENT SQLID
-- Set the name column default to the current schema: CREATE TABLE mytable (id int, name VARCHAR(128) DEFAULT CURRENT SQLID) -- Inserts default value of current schema value into the table: INSERT INTO mytable(id) VALUES (1) -- Returns the rows with the same name as the current schema: SELECT name FROM mytable WHERE name = CURRENT SCHEMA