Creating Empty Queries

Developers using Derby in existing applications might need to create "empty" queries with the right result shape for filling in bits of functionality Derby does not supply. Empty queries of the right size and shape can be formed off a single values table and a "WHERE FALSE" condition:

SELECT *
FROM (VALUES ('',1,"TRUE")) AS ProcedureInfo(ProcedureName,NumParameters, 
ProcedureValid)
WHERE 1=0