Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
Get all table names and type from SQL query |
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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |