LIB SHOW

Core command LI SH LISH

Displays a SQL query from the library

Arguments

<name> (mandatory) a file name, @alias, or search term

Examples

LIB SHOW COUNTRY.SQL

Notes

Displays the content of a saved query from the SQL library: LIB SHOW <name>.

name is mandatory, matched against the file's relative path, a declared @alias, or (if unambiguous) its bare file name, same resolution as LIB RUN/LIB DEL; the .sql extension is appended automatically if omitted and nothing else matched. Prints the entry's full content, metadata header included, or an error if no such entry exists. Also prints a one-line warning, without refusing to show the content, for each of the entry's @instance/ @environment metadata that doesn't match the current connection's instance/environment (see docs/SQL_LIBRARY_AND_SCRIPTS.md, section 4).

Last modified in release 5.0.8.