On this page

LIB TREE

Core command LI TR LITR

Shows the folders and Scripts of the Scripts Library as a tree.

Syntax

LIB TREE [<folder>] [ALL]

Arguments

Argument	Required	Values	Default
`<folder>`	No	A folder of the Scripts Library, relative to its root	The whole library
`ALL`	No	Every Script, whatever its Database Group and Environment	The Scripts of the current connection

Examples

LIB TREE;
LIB TREE reports;
LIB TREE reports/finance ALL;

Example session

LIB TREE ALL;
Scripts Library tree (every Database Group/environment, 6 Scripts):
admin/ (2)
  cleanup.bsql         [deprecated] Removes test rows
  oracle_sessions.sql  Open sessions
cities/ (1)
  capitals.sql         [draft] Capital of each country
countries/ (3)
  by-codes.sql         Countries by ISO code
  copy-of-largest.sql  A copy someone made
  largest.sql          Largest countries of a continent

The Scripts Library as a tree

Details

What it shows

The folders of the Scripts Library as a tree: each folder with the number of Scripts it holds (subfolders included), then its subfolders and its Scripts. Each Script line gives its name and its description, shortened to the terminal width; a draft or deprecated Script is marked [draft] or [deprecated].

Which Scripts

The same Scripts as LIB LIST: those that apply to the current connection's Database Group and Environment, or every Script with ALL. A folder with no Script in that scope is not shown. Archived Scripts never are.

<folder> shows only that folder, a path relative to the library root (reports/finance).
Folders come first, then Scripts, each sorted alphabetically ignoring case, as in the BroadSQL Editor.

The tree is drawn with plain spaces, so it reads the same in every console and theme.

Used in these how-tos

How do I organize my saved queries so that I can find them again?

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.