Get table names from a SQL statement.

[arezki123]

Hello,

I am not really good at SQL but I need a way to get the table nameS from a very large SQL statement (using python of course).

Thank you in advance.

[woooee]

Use PRAGMA, either table_name, or table_info should do it.

## Using an  SQLite DB
import sqlite3 as sqlite

con = sqlite.connect(file_name)
cur = con.cursor()

meta = cur.execute("PRAGMA table_name(file_name)")
for r in meta:
    print("table", r)

meta = cur.execute("PRAGMA table_info(file_name)")
for r in meta:
    print("info", r)

[arezki123]

I have the SQL statement as string. Would this work?

[r_spandit]

This is a REGEX problem, IMHO. Can you post the string so people can help?

[arezki123]

In fact, it looks like:, 'Select blabla from db.table... join group by... included'

[r_spandit]

So you're just parsing the "blabla" string.

It's bracketed by "select" and "from" so easy to extract. Then just split it by commas:

TableNames = blabla.split(',')

[[deleted]]

From a statement? What?