Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

Sun, Sep 15 2019 2:50 PM	Permanent Link
Marcello Bachechi	Hello all, is there a way to get all of the table names from a SQL query? Also, is there a way to get the fields and types from another query?
Sun, Sep 15 2019 3:56 PM	Permanent Link
Raul Team Elevate	On 9/15/2019 2:50 PM, Marcello Bachechi wrote: > Hello all, is there a way to get all of the table names from a SQL query? Also, is there a way to get the fields and types from another query? Yes - thru system information See https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Tables_Table and https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=TableColumns_Table Raul
Sun, Sep 15 2019 4:32 PM	Permanent Link
Marcello Bachechi	Raul wrote: On 9/15/2019 2:50 PM, Marcello Bachechi wrote: > Hello all, is there a way to get all of the table names from a SQL query? Also, is there a way to get the fields and types from another query? Yes - thru system information See https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=Tables_Table and https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=TableColumns_Table Raul Awesome works great! Thank you! Just for others here are the SQL queries themselves SELECT * FROM information.Tables SELECT * FROM information.TableColumns