Searching For OpenInsight Tables by Name

Here are two tips for finding currently attached tables in OpenInsight if you can only remember part of the table name.

Both tips are performed at TCL (The Command Line) in OpenInsight. Press F5 while in development mode to access TCL.

Use the Assistant

Type the command LIST and click the 'Assistant' button. A popup of currently attached tables will appear. Use the Search button to find the table by searching for part of the name.

Search SYSTABLES

Information about the currently attached tables are stored in the SYSTABLES table. You can search it from TCL with this command:

LIST SYSTABLES WITH @ID CONTAINING 'TOFIND'

Where TOFIND is your search term. A list of table names matching the query will appear.

Share this post

Leave a comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
By submitting this form, you accept the Mollom privacy policy.

About Us

Congruity Service is a technology solutions company bringing the best technology solutions to OpenInsight projects, Drupal sites, servers, networks, and your technology needs.