BroadSQL BroadSQL Downloads
Documentation / Commands / SCRIPT LIST

SCRIPT LIST

Core command SC LI SCLI

Displays the list of files in the scripts catalog, scoped to the current connection's Database Group and environment by default

Arguments

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

Examples

SCRIPT LIST DAILY;
SCRIPT LIST ALL;
SCRIPT LIST ARCHIVES;

Notes

Lists the entries in the scripts catalog: SCRIPT LIST [<searchTerm>|ALL|ARCHIVES].

Same shape as LIB LIST (see its Javadoc and docs/SQL_LIBRARY_AND_SCRIPTS.md, sections 3, 4, 4a) applied to the Scripts root instead of SqlLib: Database Group/environment-scoped by default, ALL/ARCHIVES keywords, grid output, minus the Params column, which is a LIB RUN-specific (%N) concept that doesn't apply to scripts.

Only shows top-level entries by default: an entry stored in a subfolder of Scripts is left out of the grid unless ListSubfolders=true is set in BroadSQL.ini (see ConsoleSettings#isListSubfolders), independent of the Database Group/environment scoping above. Subfolders are still resolved correctly by every other command (RUN/SHOW/ EDIT/DEL/FIND/...) regardless of this setting; it only affects what this grid displays.

Last modified in release 5.1.6.

← All commands