LIB LIST

Core command LI LI LILI

Display list of files in the SQL library, scoped to the current connection's instance and environment by default

Arguments

<searchTerm> (optional) a search term, or the literal ALL (every instance/environment) / ARCHIVES (soft-deleted entries)

Examples

LIB LIST COUNTRY;
LIB LIST ALL;
LIB LIST ARCHIVES;

Notes

Lists the queries saved in the SQL library: LIB LIST [<searchTerm>|ALL|ARCHIVES].

With no argument, shows a grid of every entry whose @instance and @environment metadata both match the current connection's instance/environment, are tagged ALL, or carry no such tag at all (the NONE sentinel: untagged entries are never hidden on either dimension). <searchTerm> filters further by a case-insensitive substring of the file's relative path, same as before. The literal keyword ALL lifts both scoping dimensions, showing every entry regardless of instance or environment; ARCHIVES lists soft-deleted entries instead (see LIB DEL/LIB UNDO/LIB RESTORE).

See docs/SQL_LIBRARY_AND_SCRIPTS.md (sections 3, 4, 4a) for the full design.

Last modified in release 5.1.2.