Search form

Searching For OpenInsight Tables by Name

10 Feb

Searching For OpenInsight Tables by Name

By OpenInsight 0 Comments

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

Author

Jared Bratu's picture

Long time network sysadmin with proclivity to coding. Why do something twice when it can be scripted once? With a wide range of familiar technology skills Jared tries to apply the best aspects of each technology to projects leaving them better than they were before.

Leave a comment

More information about text formats

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.
CAPTCHA
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.

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.