Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I need to filter/find and list tables using the sqlline !tables command. For example, these are the type of queries i wish to fire Find out all the tables in a particular schema s1 All tables ...
Question
sqlline
#1: Initial revision
by
Abbas Gadhia
·
2024-09-26T17:50:54Z (about 2 months ago)
Using sqlline, how do you filter/find tables using the !tables command
I need to filter/find and list tables using the sqlline `!tables` command. For example, these are the type of queries i wish to fire 1. Find out all the tables in a particular schema `s1` 2. All tables that start with t0 3. All tables whose schema name ends with 20 and whose table name start with `x` 4. All the "table", not "views" in a particular schema `s19` 5. Get all the views in the system All i see in the documentation is the following > tables — List all the tables in the database, schema, by pattern > > Synopsis !tables It mentions "by pattern" but no information on the pattern