--show_tables

Switch

--show_tables [like]

Description

See all available non-feature tables in a given database

SQL style wildcards ('%') will work with the optional like argument

Argument and Default Value

An optional SQL LIKE-style pattern string. Default: False when the flag is absent; True (matches everything) when given with no pattern.

Details

Runs a MySQL SHOW TABLES [LIKE 'pattern'] against -d and prints the results; excludes feature tables, which are listed separately by --show_feature_tables. This is a read-only inspection switch.

Other Switches

Required Switches:

-d

Example Commands

Show all non-feature tables:

dlatkInterface.py -d dla_tutorial

Found 5 available tables
blog_outcomes
blog_outcomes_rand
dummy_table
msgs
msgs_rand

Show all non-feature tables that begin with blog:

dlatkInterface.py -d dla_tutorial  --show_tables 'blog%'

Found 2 available tables
blog_outcomes
blog_outcomes_rand