Open
Description
RDB$SQL.PARSE_UNQUALIFIED_NAMES
is a selectable procedure that parses a list of unqualified SQL names and returns one row for each name. The input must follow parse rules for names and the output of unquoted names are uppercased.
select *
from rdb$sql.parse_unqualified_names('schema1, schema2, "schema3", "schema 4", "schema ""5"""');
-- SCHEMA1
-- SCHEMA2
-- schema3
-- "schema 4"
-- "schema "5"